Nitish
Reputation: 1736
How to change permission of a file created using UTL_FILE.FOPEN?
I have an oracle procedure which creates a text file using the UTL_FILE.FOPEN function. The file is created with permission 660. How can I change the permission of the file without using chmod?(I don't have access to the server)
Upvotes: 3
Views: 14715
Answers (1)
Frank Schmitt
Reputation: 30775
You could change the umask of the Unix user that owns the Oracle process (resp. ask the system administrator to perform this task for your), see
Upvotes: 4
Related Questions
- UTL_FILE.FOPEN() procedure not accepting path for directory?
- How to write to files using utl_file in oracle
- Where can I access a file from my oracle db with UTL_FILE?
- UTL_FILE: Could not create a new file
- Error when trying to write to file
- Granting correct permissions to the UTL_FILE method
- utl_file fopen - I'm unable to to write text to a file
- Trying to read the file using utl_file method
- utl_file.fopen without 'create directory ... as ...'
- Error in opening a file residing on server through utl_file.open!