Re: Trigger - help!!!

From: Sajit Kalidas <sajit_at_infowave.co.za>
Date: Fri, 16 Nov 2001 15:45:13 +0200
Message-ID: <3bf5180d$0$228@hades.is.co.za>

Hi,

If you change the trigger to a row-level trigger, then you can use the :new.id variable. Just include the 'for each row' statement before the declare statement.

Regards

Sajit Kalidas

"David Jeyathilak" <david_at_ionideainteractive.com> wrote in message news:3e9566e2.0111160500.442d8b56_at_posting.google.com...
> Hi,
>
> create table1(
> qty number(10),
> id varchar2(5)
> );
>
> I call the following trigger on update/insert on table1. How do I get
> the value of 'id' which was just inserted in table1?
>
> create or replace trigger trgA
> after update or insert on table1
> declare
> cursor c1 is select qty from table1 where id='value of id which was
> just inserted';
> begin
> end;
Received on Fri Nov 16 2001 - 07:45:13 CST