-
How can I disable or enable a trigger withint the same tigger.
thank you
-
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 ?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|