Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Kansas, USA

    Unanswered: Trigger after executing a procedure?

    Hello all,

    I don't see anywhere in the docs a way to create a trigger which will fire before or after the execution of a procedure. I'd like to be abe to log the execution of a particular Oracle provided procedure, can't figure out how to do it. This is not a procedure that I would manually modify, to put the audit code within, hence the trigger.


    -Adam vonNIeda

  2. #2
    Join Date
    Sep 2003
    The Netherlands

    triggers only fire after a DML statement on a table, so using a trigger is not the right way.
    You'll have to modify the procedure to call another procedure that does the auditing.

    Hope this helps
    Edwin van Hattem
    OCP DBA / System analyst

Posting Permissions

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