Re: UTL_FILE problem

Mark:

Thanks for your suggestion. I've tried it with and without the slash, on both the root and lower level directories. No luck.

Any other ideas?

Thanks,

Bob

In article <37d3ca96.0_at_145.227.194.253>,   "Mark G" <someone_at_hot> wrote:
> I'm always dubious about reading/writing a file using utl_file on the
root
> of a drive.
>
> Normally, you would declare the directory without the trailing slash
>
> DECLARE
> v_filename VARCHAR2(12) := 'TEST.MAIL';
> v_file_loc VARCHAR2(40) := 'C:';
>
> However, because you are dealin with the root directory, i'm not sure
if you
> need it or not. Try it without.
>
> M
>
> Bob wrote in message <7qu8hn$5vo$1_at_nnrp1.deja.com>...
> >Hi all:
> >
> >I'm trying to use UTL_FILE (for the first time ever), to write a file
on
> >an NT Server. Whenever I try to run it, I get a
UTL_FILE.INVALID_PATH
> >exception.
> >
> >I've modified initorcl.ora to include UTL_FILE_DIR = * (for
> >testing--initially I had it limited to one specific directory) and
I've
> >stopped and restarted ORCL. Actually, I've rebooted the server just
to
> >be sure. I'm running the script on on the server, too.
> >
> >Here's my code:
> >
> >DECLARE
> > v_filename VARCHAR2(12) := 'TEST.MAIL';
> > v_file_loc VARCHAR2(40) := 'C:\';
> > v_file_mode VARCHAR2(1) := 'A';
> > v_file_handle UTL_FILE.FILE_TYPE;
> >
> >BEGIN
> > v_file_handle := UTL_FILE.FOPEN (v_file_loc,
> > v_filename,
> > v_file_mode);
> >
> >(I've also tried directories other than the root.) Does anyone have
any
> >clues about what I might be doing wrong?
> >
> >Thank, very much, in advance.
> >
> >Bob
> >--
> >Bob M.
> >
> >Step outside. The graphics are AMAZING!
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
>
>

--
Bob M.

Step outside. The graphics are AMAZING!

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 07 1999 - 22:18:55 CDT