Re: UTL_FILE problem

please refer to
http://x45.deja.com/[ST_rn=ap,ST_Tracker=0508]/getdoc.xp? AN=521191496&CONTEXT=936579235.297599161&hitnum=0 that lists 2 pitfalls I had to solve for using UTL_FILE.

regards, Stephan

In article <7qu8hn$5vo$1_at_nnrp1.deja.com>,   Bob <meyer_b_at_my-deja.com> wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sun Sep 05 1999 - 19:55:50 CDT