passing parametets to a stored procedure using triggers
650243Sep 4 2008 — edited Sep 5 2008I have a base table, i would like to fire an email when there is an insert or update in that base table?
I have created a trigger on that base table, but i m not able to pass the parameter values into my stored procedure(which fires the email) using that trigger. can any one help me out?
test 1 is the base table with columns c1,c2,c3
test2 in the trigger on that base table which sends out the emails using the stored package.
test3 in the stored package with inputs i1,i2
i want to get the values in c1 and c2 for every insert into i1 and i2.