Home » SQL & PL/SQL » SQL & PL/SQL » Error messages
Error messages [message #36493] Fri, 30 November 2001 01:59 Go to next message
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 Go to previous message
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...

----------------------------------------------------------------------
Previous Topic: Database System Triggers - Urgent
Next Topic: Raise _application_error
Goto Forum:
  


Current Time: Thu Mar 28 07:48:55 CDT 2024