problem with trigger! [message #819] |
Wed, 06 March 2002 03:20 |
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 |
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.
--------------------
|
|
|