Home » SQL & PL/SQL » SQL & PL/SQL » utl_file question
utl_file question [message #35759] Fri, 12 October 2001 07:22 Go to next message
Jim Jowe
Messages: 3
Registered: October 2001
Junior Member
Whenever I use utl_file.fileopen() or fileclose() functions in PL/SQL to write a procedure, I always get a error when I run it:
" PL/SQL: unhandled user-defined exception at "SYS.UTL_FILE", line 98 "

what does that mean? Why I can not use the utl_file functions? Thanks,

----------------------------------------------------------------------
Re: utl_file question [message #35760 is a reply to message #35759] Fri, 12 October 2001 07:34 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
there are set of utl_file package specific exception in that package. write debug statements for all exceptions in exception handling part and you will come to know what exception is raised.

SURESH

----------------------------------------------------------------------
Previous Topic: pl/sql server pager
Next Topic: I can't display data form a variable
Goto Forum:
  


Current Time: Fri Apr 19 11:49:24 CDT 2024