insert or update trigger passing value to stored procedure
My task is to write a trigger that will pass a value from an insert or update to a stored procedure.
It's Friday and I am not clearly thinking, forgive me ...
Create or replace trigger <trigger name>
after insert or update of table XXX
for each row
execute procedure Just_Do_It
(userid = new.user_id).
so table XXX has the column userid, and I want the trigger to get it and pass it along to Just_Do_It.
what am I missing ?
Thank you.