Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE - How do I call its funcs/procs form a stored proc
Your DBA needs to add an 'authorization' to the init for your database.
There is a parameter that must be set which allows access to certain paths
and/or directories for UTL_FILE.
camicro wrote in message <714oj0$bql$1_at_garnet.nbnet.nb.ca>...
>I am writing a package that will create various flat ascii files but have
>been unsuccessful in my attempts to utilize oracles utl_file package to do
>my file i/o. example:
> handle :=sys.utl_file.fopen('/unixdirectory','flatfilename.dat','w')
>
>various errors occur regarding the handle declaration (I've tried various
>declarations - number,binary integer,char).
>
>Any suggestions would be greatly appreciated,
>Andrew Johnson
>camicro_at_nbnet.nb.ca
>
>
>
Received on Tue Oct 27 1998 - 22:43:11 CST