Title: unhandled user-defined exception
I am attaching the source
code of the trigger ,Please let me know where I made mistake
.Thanks..
Venu
-Original Message-From: Venugopal, R (GEP,
Contractor) Sent: Thursday, May 17, 2001 7:25 PMTo:
Multiple recipients of
Title: unhandled user-defined exception
Add
an EXCEPTION to your code and try to trap the error 6510
-Message d'origine-De: Venugopal, R (GEP,
Contractor) [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 17
mai 2001 13:25À: Multiple recipients of list
ORACLE-LObjet: unhandled
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
03:25
PMTo: Multiple recipients of list ORACLE-LSubject: 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
-LOnderwerp: RE: unhandled user-defined exception
I am attaching the source
code of the trigger ,Please let me know where I made mistake
.Thanks..
Venu
-Original Message-From: Venugopal, R (GEP,
Contractor) Sent: Thursday, May 17, 2001 7:25 PMTo
The trigger code would probably help...
--- Venugopal, R (GEP, Contractor)
[EMAIL PROTECTED] 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
Title: unhandled user-defined exception
You do a DMBS-OUTPUT the SQLMM , SQLCODE to check
on what might be the coz of error...in you PL/SQL.
-Original Message-From: Venugopal, R (GEP,
Contractor) [mailto:[EMAIL PROTECTED]]Sent: Thursday, May
17, 2001 7:25 PMTo: Multiple