Re: NEWBIE; cannot write to a file

From: <mpir_at_compuserve.com>
Date: Thu, 22 Jul 1999 19:23:13 GMT
Message-ID: <7n7r2j$3e1$1@nnrp1.deja.com>

1-Where does the UTL_FILE_DIR parm in the initorcl.ora file point? 2-In the open, I think the W needs to be 'W'

In article <37937CF2.47565383_at_wcom.com>, "Thomas E. Johnston" <Thomas.E.Johnston_at_wcom.com> wrote:
> Not able to write a simple message to a file.
>
> 1 DECLARE
> 2 output_file UTL_FILE.FILE_TYPE;
> 3 BEGIN
> 4 output_file := UTL_FILE.FOPEN('C:\','tomout.txt','w');
> 5 UTL_FILE.PUT_LINE( output_file,'write to a file');
> 6 UTL_FILE.FCLOSE(output_file);
> 7* END;
> SQL> /
> DECLARE
> *
> ERROR at line 1:
> ORA-06510: PL/SQL: unhandled user-defined exception
> ORA-06512: at "SYS.UTL_FILE", line 88
> ORA-06512: at "SYS.UTL_FILE", line 146
> ORA-06512: at line 4
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 22 1999 - 14:23:13 CDT