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!

UTL_FILE_DIR and UTL_FILE.FOPEN

mnbvcxzOct 10 2001
Hello.
If I set UTL_FILE_DIR = /episdata, do I also need to set the
File Location argument in UTL_FILE.FOPEN = /episdata ?
When I do this, UTL_FILE.FOPEN appears to be failing with an
INVALID_PATH error. Out DBA's are thinking that UTL_FILE.FOPEN
may be interpreting this situation to mean /episdata/episdata.
I've looked at the UTL_FILE.FOPEN documentation but I couldn't
tell if I needed to pass '/episdata' to UTL_FILE.FOPEN or not.
Does anyone have some experience or ideas about this?
Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2001
Added on Oct 10 2001
3 comments
507 views