Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE - How do I call its funcs/procs form a stored proc

Re: UTL_FILE - How do I call its funcs/procs form a stored proc

From: Terry Engelstad <terry_at_interaccess.com>
Date: Tue, 27 Oct 1998 22:43:11 -0600
Message-ID: <7167lh$8v9$1@supernews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US