Mutating Error in Triggers

[vamsioracle]

thanks all

it worked for me.

I created a after insert trigger and used pragma autonomous transaction, from there i had to call procedure that has the logic and one more procedure that from here, to send a mail.

for some reason, it worked only if the calling is indirect (calling one procedure from other)


vamsi

[swapnilbunty123]

can we Store all records of column from table on which trigger is written ????

Try this:

[code=oracle]

create or replace trigger xx_routing
after insert
on wf_routing_rule s
for each row
begin

proc1(:new.role ,:new.attribute );

--- here i call the procedure that has the following code-------

/*select role,attribute into x,y from wf_routing_rule s where begin_date >= to_date(sysdate );*/
--now do what ever you want to with the input parameters rolw and attribute

utl_smtp.conn(h ost,port)
--------

end procedure;
[/code]

My question is :
1. can we Store all records of column from table on which trigger is written ????
e.g. here in "wf_routing_rul es" this table can i get all role list which is stored in array and pass as an parameter to Procedure !!

Thanx !