| Error messages [message #36493] |
Fri, 30 November 2001 01:59  |
Kate
Messages: 6
Registered: October 2001
|
Junior Member |
|
|
Hello!
I have written a trigger, that is created without errors and which should raise an exception when an invalid value is inserted.
When I try to do that insertion, I correctly get the response from the system that I cannot:
ORA-20099: Not valid (the error that I print)
Togther with that I get the errors:
ORA-06512: at "MARIA.TRIG", line 5
ORA-04088: error during execution of trigger 'MARIA.TRIG'
I have searched and found what they mean but I do not understand how to handle them.
Any suggestion;
Thank you a lot!
Kate
----------------------------------------------------------------------
|
|
|
|
| Re: Error messages [message #36495 is a reply to message #36493] |
Fri, 30 November 2001 03:19  |
Rob Baillie
Messages: 33
Registered: November 2001
|
Member |
|
|
Well... you're only actually getting the one error there. The other two show you the report path.
Looking the Oracle error messages reference...
ORA-06512: at str line num
Cause: This is usually the last of a message stack and indicates where a problem occurred in the PL/SQL code.
ORA-04088: error during execution of trigger name.name
Cause: A runtime error occurred during execution of a trigger.
And so reading the error messages backward...
A runtime error occured in your trigger, it occured at line xxx, and the error was 'Not valid'.
This is completely normal...
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
