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.FOPEN ... INVALID_PATH exception problem

Re: UTL_FILE.FOPEN ... INVALID_PATH exception problem

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 7 Feb 1999 09:19:15 -0000
Message-ID: <918379401.4300.0.nnrp-11.9e984b29@news.demon.co.uk>

utl_file has to write to a directory on the server, and has to have that directory specified in the init.ora file, and the directory has to be writable by the id of the process running the Oracle executable.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

> Since this is a local drive on my PC, I assume that
>INIT.ORA is not required. For security and performance
>reasons, our system people do *NOT* want a bunch of
>end-users writing files (even to their own accounts) on
>the database server machine, so this has to go to my local
>machine. What am I doing wrong?
>
Received on Sun Feb 07 1999 - 03:19:15 CST

Original text of this message

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