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!

utl_file.fopen ORA-29283 with open_mode = 'W' (works with open_mode = 'R')

Michael TsilikidisApr 17 2013 — edited Apr 29 2013

Greetings.

I have this annoying ORA-29283 when I try to open a file location.

I found the exact command which causes this error: utl_file.fopen(location, filename, open_mode, 32767) -- max_linesize = 32767

The weird thing is that the function works fine when I pass an 'r' for open_mode but when I give it an 'w' it throws the error.

The file I am trying to access exists, the directory in the database exists (I gave it read, write, execute to PUBLIC), the physical path shown by the db directory exists and has all the permissions (777).

Any other ideas causing this error?

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 27 2013

Added on Apr 17 2013

6 comments

937 views