Home » RDBMS Server » Server Administration » Re: utl_file error ARGH
Re: utl_file error ARGH [message #371716] Wed, 29 November 2000 07:10
John R
Messages: 156
Registered: March 2000
Senior Member
I'm afraid my life is too short to do a thorough code check for you.
However, things you could do to find out the problem include:

1) Check that you aren't trying to write out more than 1024 characters at once (UTL-File limit)
2) Add an exception handler to check for the various exceptions that UTL_FILE raises (Invalid_PAth, Invalid_Mode, Invalid_Operation, Read_Error, Write_Error, Internal_Error, Value_Error) to tell you exactly what is going wrong.

Hope this helps
Previous Topic: Re: help: foreign key from 2 tables
Next Topic: ORA-1555
Goto Forum:
  


Current Time: Fri May 03 00:49:45 CDT 2024