Re: debugging a trigger

From: Jeff Thompson <jeff.thompson_at_e-markets.com>
Date: Mon, 11 Oct 1999 13:28:38 -0500
Message-ID: <38022C56.97EB1602@e-markets.com>

Christ Follower wrote:

> I am trying to create a relatively simple trigger but constently
> getting compilation error. This trigger has an insert statement. If I
> issue this insert statement at SQL*Plus prompt, it is correct. Any
> ideas? What is the best way to find out trigger error other than just
> saying "Warning: Trigger created with compilation errors."
>
> Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy

Check security on all possible objects that would be affected by the insert. Also, supposedly "show errors" is suppose to work, but I just query the view "ALL_ERRORS" and get the text of the error from there.

Good luck!

Jeff Received on Mon Oct 11 1999 - 13:28:38 CDT