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: UTL_FILE : invalid_path error

Re: UTL_FILE : invalid_path error

From: AleX <korrozia_at_my-deja.com>
Date: Fri, 23 Jul 1999 01:33:43 GMT
Message-ID: <7n8gpn$ang$1@nnrp1.deja.com>


In article <7n675r$42m$1_at_aklobs.kc.net.nz>,   "Alistair Connor" <alistair_at_webmasters.co.nz> wrote:
> Modifying a package which uses the UTL_FILE package.
> Package runs OK on production machine (O 7.3 on Solaris)
> but on Development box (O 8.0.5 on Linux Redhat 5.1)
> I get invalid_path error every time I try to open a file
(UTL_FILE.FOPEN)
>
> This happens even when the path is /tmp i.e. it is not a file rights
issue.
>
> Any clues?
>

set this in your init.ora

utl_file_dir=*

this should do the trick.

--

                 Alex Shterenberg

"I hate people. I think they should suffer as much as  possible, and therefore I'm into those old communist

         dictatorships." - Euronymous, Mayhem

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 22 1999 - 20:33:43 CDT

Original text of this message

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