Re: Problem with triggers

From: Lucy Cornelese <lcornele_at_caiw.nl>
Date: 1997/08/15
Message-ID: <33f46de2.1799852@194.178.9.131>#1/1

On Wed, 13 Aug 1997 20:31:29 -0600, turnerk <turnerk_at_dim.com> wrote:

>The table and the sequence create just fine, but I can not create the trigger.
>The only error message that SQL*Plus(3.3) gives me is an error compiling the
>trigger. I type: "show errors" and it says: "no errors".
>

You can't use "show errors" for trigger-errors although the errors are in the same table as procedure/function/package-errors. Show errors works only for procedure/function/package-errors. You must write your own select-statement from the table user-errors to show trigger-errors. Received on Fri Aug 15 1997 - 00:00:00 CDT