Re: SYS.UTL_FILE Package

A copy of this was sent to miaemp_at_my-deja.com (if that email address didn't require changing) On Tue, 25 Jan 2000 19:41:48 GMT, you 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?
>

have you set up utl_file_dir in your init.ora to allow writing to /home/user/source ?

>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.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Jan 25 2000 - 14:05:41 CST