Results 1 to 2 of 2

Thread: Dumb Question

  1. #1
    Join Date
    Jan 2004

    Unanswered: Dumb Question

    I apologize in advance if this is a no brainer.

    I cannot determine how to update a table and not fire the trigger on it.

    Example: We have a trigger to audit changes to a table. We have an area of our software where we want to insert some new records automatically, this happens often and does not need to be audited. However, other changes to this table must be audited.

    How can I perform these inserts without firing the trigger?

    I do not want to disable the trigger often because someone else may be inserting records at this same time.

    Thanks in advance

  2. #2
    Join Date
    Jun 2004
    Liverpool, NY USA
    You can't conditionally disable the trigger, but you can set a session variable that would be able to be read by the trigger to determine if it is to skip it's audit. Check out the information on DBMS_SESSION.SET_CONTEXT
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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