Referencing a input parameter in a stored proc from a trigger
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Referencing a input parameter in a stored proc from a trigger

  1. #1
    Join Date
    Dec 2000
    Posts
    87

    Angry

    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.


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width