Re: compiler for PL/SQL?

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Thu, 18 Mar 1999 20:03:01 +0100
Message-ID: <36f14deb$0$10690@pascal>

frank wrote
>Because I just got an error message when I fired the trigger.
>Not while compiling it. (and it was not a runtime error)

Then your database layout or database permissions have meanwhile changed. Or you simply ignored the warning when the trigger was created in the first place.

>And then I usually got something like:
>Trigger % is not valid.Verification failed.
>What didn't help at all.

show errors trigger <trigger name>

Arjan. Received on Thu Mar 18 1999 - 13:03:01 CST