Nice little article on this in July/August 1999 issue of Oracle
magazine...
Suresh Bhat wrote:
>
> 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
> Oracleguru
> www.oracleguru.net
>
> Talko Dijkhuis <DijkhuisT_at_Vertis.nl> wrote in article
> <3779113E.96F0A489_at_Vertis.nl>...
> > 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 Wed Jun 30 1999 - 06:46:26 CDT
