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: Michael Finger <michael.finger_at_lhsystems.com>
Date: Fri, 9 Feb 2001 09:21:29 +0100
Message-ID: <9609af$6jm@ar4dec01.ar4.fra.dlh.de>

That's it thanks a lot
Michael

Al Hetzel schrieb in Nachricht
<0B3E9C481E57B479.026005A74D1EEBEF.0208AD44CEE0BE3A_at_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 Fri Feb 09 2001 - 02:21:29 CST

Original text of this message

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