Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-29283: invalid file operation

532632Dec 3 2008 — edited May 19 2011
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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 16 2011
Added on Dec 3 2008
15 comments
54,939 views