Re: Trigger - help!!!

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

where id = :new.id

It is not going to work however, because Oracle doesn't allow you to select from a table which is mutating.
Could you please specify what you want to accomplish?

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address