Referencing a input parameter in a stored proc from a trigger

[coolmandba]

Hi all,

Does anyone know how to reference a input parameter that is passed into a stored procedure from a trigger?

Say if I have an 'insert' statement that accepts input parameters from user, that insert statement in turn fires an insert trigger which require to use the input parameter passed into that store procedure. How can it be achieved? What's the syntax for it? Please show me an example if you can, thanks a lot.

[sambavan]

You can fire the before insert trigger and when you fire this,
:new would have the value form that insert parameter and :0ld would have value form the old parameter.

Sam