Re: No Need For UTL_FILE_DIR?

Dennis Hancy wrote:

> Are there any issues with specify a UNIX path for the directory in
> FOPEN?
>
> I keep getting the Invalid Directory Path error. I've tried several
> directories, thinking it was an access right problem, but nothing
> works.
>
> This is the syntax I am using:
>
> v_file_handle := utl_file.fopen('/APPS/DB/fa/1.0.0/out', 'abc.txt',
> 'w');
>
>
> Dennis Hancy
> Eaton Corporation
> Cleveland, OH

What version of Oracle?
Is that path permitted by your init.ora?

If you are in 9i you should create a directory: http://www.psoug.org/reference/directories.html Then use it, rather than a hard-coded path with UTL_FILE.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)