Re: problem with a trigger

"BlackEagle" <slimane_at_tsk.be> wrote...
>
> Thanx a lot Carlos ;)
> the ')' and the language were the problems...
> Now the triggers to their job but still I still get an error
afterwards like
> ora-06512: in "username.reservation_restrictions, line 3
> ora-04088: failure by executing trigger
'username.reservation_restrictions'.
> is this normal? because the trigger does his job, before these two
errors I
> get the message I want.
>
> thanks
>
Hi BlackEagle,

sorry, 'disgusting' was a bit harsh but I prefer *real* names. Actually I did point you to one of your errors (if you re-read my answer you'll find it). To help you with your remaining problems it would be helpful to have a posting of the complete trigger.

To let the rdbms show you errors at (well, after compile time) you can issue the 'show error trigger <trigger_name>' command. That will immediately point to the erroneous part(s) of the compiled code.

Greetings,
Guido Received on Thu Dec 11 2003 - 09:52:11 CET