In article <8qai64$ndb$1_at_nnrp1.deja.com>,
pequeberto_at_my-deja.com wrote:
> Hi all!
>
> I'm trying to write a PL/SQL program using the package UTL_FILE, but I
> can't open de file (using the function fopen). The problem seems to be
> the path, because it always jump to the 'INVALID_PATH' exception. Do
> you have any example of a program that uses this function?
> I think I've tried all type of strings to change the path: 'D:\', 'D',
> 'D:/', 'D:\\', '/home', ...
>
> Thanks in advance.
>
What version of Oracle are you using. I know with versions 7.3 and 8
that utl_file only reads/writes to files on the database server. The
directories that the files are in must be authorized for use via the
ult_file_dir init.ora parameter. Did you authorize your directories?
--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Sep 20 2000 - 00:00:00 CDT
