Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Problem with Trigger

Re: Problem with Trigger

From: Al Hetzel <alhetzel_at_bigfoot.com>
Date: Wed, 07 Feb 2001 02:18:45 GMT
Message-ID: <0B3E9C481E57B479.026005A74D1EEBEF.0208AD44CEE0BE3A@lp.airnews.net>

I believe the code you want is:

show errors trigger SLOT

On Tue, 6 Feb 2001 10:55:39 +0100, "Michael Finger" <michael.finger_at_lhsystems.com> wrote:

>Hi,
>i have a problem using a trigger.
>I have written and compiled a package and package body without an error, the
>necessary database link works also properly.
>When comiling the trigger I get the response :
>Warning: Trigger altered with compilation errors.
>
>When using the trigger :
>ORA-04098: trigger 'SLOT' is invalid and failed re-validation
>
>I don#t know where I can find the problem or the errors mentioned above. I
>have checked the column names etc. everthing should be ok.
>Has anybody an idea how to find the problem ?
>Thanks a lot
>Michael
>
Received on Tue Feb 06 2001 - 20:18:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US