Re: UTL_FILE Oracle object
Date: Tue, 29 Jun 1999 20:18:43 GMT
Message-ID: <01bec27d$1d04b1a0$a504fa80_at_mndnet>
Hi -
You have the correct syntax.
But you may have the write permission problem even though the error message
may not necessarily indicate it.
At least on our 7.3.3 UNIX release the utl files are written under user
oracle.
You also want to make sure that you have the following line in your
init.ora file and then stop and start the database for it to take effect.
* means any directory/sub-directory where user oracle has permission to
write a file.
utl_file_dir = *
Later !!!
Suresh Bhat
Talko Dijkhuis <DijkhuisT_at_Vertis.nl> wrote in article
<3779113E.96F0A489_at_Vertis.nl>...
Oracleguru
www.oracleguru.net
> select your directory from v$parameter so is the directory changes in
> the init file you don't have to rewrite your statement
>
> "A. el Azzouzi" wrote:
>
> > Hello there,
> >
> > I want to use the UTL_FILE oracle object to open a file, write, and
> > then close it.
> >
> > But upon opening of the file, I get some errors.
> > Can somebody tell me what is wrong with the next
> > statement:
> >
> > v_FileHandle UTL_FILE.FILE_TYPE;
> > ....
> > v_FileHandle := UTL_FILE.FOPEN('c:\sql\', 'output.txt', 'w');
> > ...
> >
> > Is the syntax for opening the file ok?
> >
> > Any reaction is welcome,
> >
> > A. el Azzouzi
>
>
Received on Tue Jun 29 1999 - 22:18:43 CEST