basic trigger information

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 Wed May 15 2002 - 18:40:26 CEST