Re: UTL_FILE.INVALID_OPERATION (trying to open file)

are you trying to access files on the server machine? UTL_FILE does can only reference files on the server not on your pc if that is what you are attempting.

sfelten_at_ipsos-asi.com wrote in message <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 Thu Jan 21 1999 - 01:35:34 CET