Re: Problem with triggers

From: Alton Ayers <altona_at_ditw.com>
Date: 1997/08/14
Message-ID: <33F3BD2A.5FFE@ditw.com>#1/1

Joe Rogers wrote:
>
> turnerk wrote:
>
> I am running Oracle 7.3.2.2 on Netware 4.1 and am having
> problems creating
> triggers. Here is the table and the trigger definition I am

.
.
.


>      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".

> 

>      This seems pretty straightforward to me.  Does anyone see

>      what might be wrong?

>      Does anyone have any better way of creating triggers since

>      SQL*Plus does not

>      give the needed help?

> 

>      Thanks for your time.

> 

>      K. Wade Turner

>      turnerk_at_dimensional.com

>
>
>
> Put a forward slash ( / ) on a line by itself after the last line of
> the trigger, so it knows the block is complete.
>
> create or replace trigger ttt_insert_trigger
> before insert on trigger_test_table for each row
> declare
> new_id number;
> begin
> select test_trigger_id.nextval into new_id from dual;
> :new.id := new_id;
> end ttt_insert_trigger;
> /
>
> It complies fine, and seems to work the way you probably intended.
>
> One other note, "show errors" doesn't work with triggers. You have to
> use "select * from user_errors" to see what went wrong.
>
>
> --
> Joe Rogers
> Intelligent Information Systems, Inc.
> joer_at_renewal-iis.com
>

Show errors will work with triggers if you use show errors TRIGGER trigger_name Received on Thu Aug 14 1997 - 00:00:00 CDT