Hi Gurus,
I have a pl/sql procedure in schema s1 that writes a csv file to a unix directory path.
1. The directory path does exist.
2. The directory path is mentioned in utl_file_dir parameter on init.ora
3. The directory path has write permission on it.
However, on executing the procedure, I get the following error:
ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line 449 ORA-29283: invalid file operation CAUSE :: EITHER DIRECTORY DOES NOT EXISTS OR DIRECTORY DO NOT HAVE PERMISSIONS TO CREATE FILE.
Is there anything else I am missing?
Many Thanks.