Re: Help with utl_file package

Hi,
  Write an exception handler and handle the follwing exceptions:     invalid_path, invalid_mode, invalid_filehandle, invalid_operation, read_error, write_error, internal_error, no_data_found, value_error. Handling these exceptions will should help in pinpointing the problem. A "when others should also help.
Hope this helps.

In article <FDJ4FL.2oA_at_midway.uchicago.edu>,   "Seigmund Akinwande Johnson" <asjohns_at_midway.uchicago.edu> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 18 1999 - 11:42:33 CDT