| Unhandled Exception in Trigger [message #87038] |
Wed, 01 December 2004 05:04  |
Zun Xing Li
Messages: 19
Registered: November 2004
|
Junior Member |
|
|
Hi,
I got an error:
FRM-40735: when-new-block-instance trigger raised unhandled exception ORA 06502.
Suggest rewite trigger, what is wrong?
Thanks for any instructions!
|
|
|
|
| Re: Unhandled Exception in Trigger [message #87046 is a reply to message #87038] |
Wed, 01 December 2004 18:04  |
Raga
Messages: 8
Registered: November 2004
|
Junior Member |
|
|
|
Check the datatypes and the width of the variables that you are using. Some type conversion may have problem or you have assigned values that can't fit into a variable.
|
|
|
|
| Re: Unhandled Exception in Trigger [message #87052 is a reply to message #87038] |
Thu, 02 December 2004 04:20 |
Adi
Messages: 38
Registered: May 2002
|
Member |
|
|
hi Zun Xing Li,
u know there are three types of exceptions or errors raised for this see help for
1. (Error_Code,Error_type,Error_Text);
2. (Dbms_Error_Code,Dbms_Error_Message);
3. (Sqlcode,Sqlerrm);
keep this three in a message box and check according to the messages that appear on the screen.
bye
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
