Re: basic trigger information
Date: Thu, 16 May 2002 06:13:21 GMT
Message-ID: <56IE8.92689$Q42.5104047_at_typhoon.austin.rr.com>
use the :new/:old (whichever is applicable) to get the new value that is being inserted into the table and pass into the procedure call... this way, you don't have to retrieve this from the table.
hope that helps,
tom
"simon taylor" <simon.taylor_at_fdlearning.com> wrote in message
news:6ffb6d34.0205150840.4efcfa3d_at_posting.google.com...
> Folks,
> Any help would be great and appreciated !!
> I'm trying to create an insert trigger that when a value is inserted
> into a table this value is then used to call a stored proc ? but am
> struggling with syntax.....
>
> create or replace trigger test after insert
> on sttest1
>
> begin
> mysp(2586, 492, sttest1.col);
> end;
>
> so if i do
> insert into sttest1 values ('me')
> then i want the value 'me'
> to go into the call of mysp....
> all the help on the net seems to a point to a for loop but i dont want
> to loop through my sttest1 table - just pull out the last inserted
> value ?
> cheer
> simon
Received on Thu May 16 2002 - 08:13:21 CEST