Re: trying to create text file using utl_file

On Aug 2, 10:39 am, mamta81 <roy.ma..._at_gmail.com> wrote:
> i am trying to create a new text file on the server using utl_file
> package in the write(w) mode but the file is not being created
> automatically. i hav to create it every time. The file should be
> created automatically isn't it?

As manuals states explicitly it creates it. Beware, if file exists it is overwritten.
If Oracle can't create file it throws an exception. do you used dreaded
"exception
 when others then
 null;
"
?

May also be that there is a bug but if you do not tell us Oracle version and Operating system
we can tell you much more.

Bye
 Cristian Cudizio

http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com Received on Thu Aug 02 2007 - 05:20:38 CDT