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

Home -> Community -> Usenet -> c.d.o.server -> Re: SYS.UTL_FILE Package

Re: SYS.UTL_FILE Package

From: bigrez <resnimi_at_mail.northgrum.com>
Date: Thu, 27 Jan 2000 22:59:48 GMT
Message-ID: <Fp0nxx.CoE%mother@herald.northgrum.com>


I had a similar problem. Everything was correct and it should have worked. I was running the PL/SQL program via Oracle's Web App Server. The DAD was set up and using the ORACLE_SID value for the database. In order for it to work though, I had to change the DAD to use the SQL*Net V2 service rather than the ORACLE_SID name. Once I did that, it worked perfectly!

miaemp_at_my-deja.com wrote in message <86ku9r$rih$1_at_nnrp1.deja.com>...
>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
Received on Thu Jan 27 2000 - 16:59:48 CST

Original text of this message

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