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

User_H7I9VJan 7 2013 — edited Jan 23 2013

Hi ,
I am using UTL_FILE_DIR for generating .txt,.csv file from pl/sql code. But as per Oracle 11g recomendation wee should replace this.
Can we use the ‘directory’ object to replace this parameter utl_file_dir per Oracle’s recommendation (for more flexibility and granular control / better security)?
The Oralce’s UTL_FILE PL/SQL package /store procedures all take ‘directory’ objects now.

How can i replace UTL_FILE_DIR. Please explain.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2013

Added on Jan 7 2013

12 comments

3,318 views