RE: unhandled user-defined exception

[Libal, Ivo]

I would say that the problem is with 'w' parameter of fopen function if the file already exists. Try tu use st like this:

Kind Regards

Ivo Libal

traceFileName := NVL(traceFile,'TRACE_'||TO_CHAR(SYSDATE,'YYYYMMDD')||'.OUT');

BEGIN

iFile := UTL_FILE.fopen(iPath, traceFileName, 'a');

EXCEPTION

WHEN OTHERS THEN

iFile := UTL_FILE.fopen(iPath, traceFileName, 'w');

END;

UTL_FILE.put_line (iFile,'* '||to_char(sysdate,'DD.MM.YYYY HH24:MI:SS')||' - '||traceInfo);

UTL_FILE.fclose (iFile);

 

-----Original Message-----
From: Muthaiah [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 03:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: unhandled user-defined exception

Hi,

You have to handle the exception explicitly. You can handle them by trapping When too_many_rows, when no_data_found, when zero_divide. After using these exceptions also if you get the error again, then you can go for when others as a final resort.

Hope this helps,

Muthaiah

At 03:25 AM 5/17/01 -0800, you wrote:

Hi Gurus 
 
   I am getting the error attached below when trigger fires. what could be the reasons
for this error.
 
DB error: ORA-06510: PL/SQL: unhandled user-defined exception 
 
 
Thanks in Advance
Venu
 

Muthaiah Chinnaveerappan (Muths),
Systems Analyst,
Chennai, India.
Tel      : 91-44-2435034
Email : [EMAIL PROTECTED]