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!

How to create a text file using util.files

user633278Feb 12 2010 — edited Feb 12 2010
Hi

I am not an expert using all of Oracle's various packages and functions, etc, but I would like to someone to explain to me simply how I can create a simple text dynamically using util.files. What I am trying to do is dump some information from a stored procedure if a particular branch in the code is hit, but I want the code to create the file rather than just have the file be there. Also, because I am going to this file in some other procedures in my PL/SQL package, I want to firstly, check to see if the file exist, and if does add to that file, but adding a new line, else create that file.

How do you do this?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2010
Added on Feb 12 2010
6 comments
926 views