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!

Unable to read the file using UTL_FILE Dir

510158May 4 2006 — edited Jul 16 2007
I need to read/write a file from/to the operating system through PLSQL Package. I used UTL_FILE package to do the same. In the application server the utl_file_dir(/usr/tmp in my system) is created as a softlink to database server.
oI want to run this package through the application server. However I am unable to read and write the file to the operating system.

I just wondering it is not reading/opening the file from the server. Please suggest me how to modify my code.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2007
Added on May 4 2006
9 comments
802 views