DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: disabling and enabling a trigger within it self

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    9
    How can I disable or enable a trigger withint the same tigger.

    thank you

  2. #2
    Join Date
    Jan 2001
    Posts
    36
    This is a new one to me. A trigger within a trigger ?

    Or are you asking how to put a statement
    'DISABLE TRIGGER' into the code of the trigger itself ?

  3. #3
    Join Date
    Jan 2001
    Posts
    9
    Yes I am trying to disable an 'update trigger' which was create for the for each row on table 'A' in order to be able to update other rows on table 'A' and then enable the trigger again.

    Because as it is I get
    ORA-04091: table name is mutating, trigger/function may not see it


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