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 :
cvmuthaiah_at_yahoo.com Received on Thu May 17 2001 - 08:23:02 CDT