Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011

    Unhappy Unanswered: procedure in a trigger

    Is it possible to use a created procedure in a trigger? If yes, how do I call it, or even pass parameters to a procedure? I cant make it work , Can anyone help me with this?

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    a trigger is just specialized PL/SQL code.
    so you invoke a procedure from within a trigger just as would be done in any other PL/SQL procedure.

    many fine coding example can be found at Ask Tom Home
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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