QUOTE (subhadra R menon @ Mar 24 2011, 09:04 AM)
But my question is using what varaible or statement would the trigger have access to these values of the insert statement.....
How will the trigger be able to access values being inserted into the table through an insert statement which causes the BEFORE INSERT statement level trigger on that particular table to be fired in the first place.Cant use new or old value references as incase of row level triggers.
Please do advice cause i am in dire need of this information.......
Also if you could share sameple code of such a statement level trigger then i would be highly obliged.
I am not much aware, that can be possible in statement but you can use row level trigger.
To avoid the mutating error:
create a package variable,
create a before row level trigger and assign the new values to the package variable,
create a statement level trigger and use the package variable inside it which has a new values.