Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYS.UTL_FILE Package
Yup!.
You need to add all the access directories in init.ora.This directory must be owned by oracle:dba.
utl_file_dir=/home/user/source
Mohamed Buhari
oracle dba
miaemp_at_my-deja.com wrote:
> I wrote a PL/SQL utility to output Stored Database Code. I am getting
> an exception of INVALID PATH from the package when I go to open the
> file. For example:
> fin := fopen('/home/user/source',
> 'test.pls',
> 'w');
> Does anyone have any ideas?
>
> TIA
> Eric Peterson
> Programmer/Analyst DBA
> Maurices Inc.
> eric_NOpeterson_at_mauriesSPAMMERS.inrg.com
>
> The views I have expressed are solely my own and not that of my
> company's.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jan 25 2000 - 13:58:36 CST