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
Systems Analyst,
Chennai, India.
Tel : 91-44-2435034
Email : [EMAIL PROTECTED]
