Re: problem with a trigger

From: Guido Konsolke <>
Date: Thu, 11 Dec 2003 09:52:11 +0100
Message-ID: <>

"BlackEagle" <> 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
> 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.

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

Original text of this message