Re: UTL_FILE.INVALID_OPERATION (trying to open file)

From: Orlando Kelly <orlando_at_orlandoweb.demon.co.uk>
Date: Wed, 27 Jan 1999 15:47:37 GMT
Message-ID: <01be453e$85af4e20$0100007f_at_660086>


I seem to remember that there is a parameter in your database initialization file that sets which directories plsql has access to. I think it is called UTL_FILE_DIR

Orlando

sfelten_at_ipsos-asi.com wrote in article <785f8v$t2p$1_at_nnrp1.dejanews.com>...
> When using the UTL_File package to Open a file I get the following
Exception
> error.
>
> UTL_FILE.INVALID_OPERATION - Due to lack of permissions for access to
the
> file. Contact dba for access rights.
>
> The file is being accessed on the local machine. The code is as follows:
 (Is
> it oracle access permissions or the local machine permissions??)
>
> v_infile := UTL_FILE.FOPEN('c:\','acctsms.txt','r');
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
 

>
Received on Wed Jan 27 1999 - 16:47:37 CET

Original text of this message