Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help with utl_file package

Help with utl_file package

From: Seigmund Akinwande Johnson <asjohns_at_midway.uchicago.edu>
Date: Fri, 18 Jun 1999 15:30:27 GMT
Message-ID: <FDJ4FL.2oA@midway.uchicago.edu>


Help,
I am trting to write to a text file from pl/sql and I keep gettin this error

ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 82
ORA-06512: at "SYS.UTL_FILE", line 120
ORA-06512: at line 5

I set the following in my init.ora
# added to access any o/s fril using UTL_FILE module utl_file_dir = c:\

begin
 declare
 f_handle utl_file.file_type ;
 begin
  f_handle := utl_file.fopen ('c:\' , 'text', 'w' ) ;   utl_file.put (f_handle, 'Hello ') ;
  utl_file.fclose(f_handle) ;
 end ;
end;
/

--
Developer Preserve Project
BSDIS
773-834-2652 Received on Fri Jun 18 1999 - 10:30:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US