Home » SQL & PL/SQL » SQL & PL/SQL » problem with trigger!
problem with trigger! [message #819] Wed, 06 March 2002 03:20 Go to next message
Sheryl
Messages: 6
Registered: November 2001
Junior Member
Hello!
When i fire a trigger,I get the following results :

ERROR at line 1:
ORA-20099: Valid_To should be greater than Valid_From
ORA-06512: at "MARIA.TRIG_DATE", line 4
ORA-04088: error during execution of trigger 'MARIA.TRIG_DATE'
I wanted only the ORA-20099 error message to appear(i have specified that action).Is it a problem that the two additional messages appear; What should i do;
Thank you very much in advance, it's a bit urgent!
Sheryl
Re: problem with trigger! [message #820 is a reply to message #819] Wed, 06 March 2002 03:54 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
it is the normal behaviour. u must be rasing application error inside the trigger.once the error is raised , it shows the top level errors from the stack, u can not stop that.

have a look at the error message ora-06512, it will give u some idea.

-----------------
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.
Action: Fix the problem causing the exception or write an exception handler for this condition. It may be necessary to contact the application or database administrator.
--------------------
Previous Topic: Invoking external application
Next Topic: What does USERENV do?
Goto Forum:
  


Current Time: Thu Mar 28 11:17:21 CDT 2024