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
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 user
/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
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
Title: unhandled user-defined exception
Hi
Venu,
Did
you set the database parameter utl_file_dir ?
Remco
-Oorspronkelijk bericht-Van: Venugopal, R (GEP,
Contractor) [mailto:[EMAIL PROTECTED]]Verzonden: donderdag
17 mei 2001 14:52Aan: Multiple recipients of list
ORACLE
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