Problems when execute Trigger

Get new comments by email
You can cancel email alerts at anytime.
Comments (3)

Gilberto in Culiacán, Mexico

82 months ago

When execute the trigger send this message

error during execution of trigger/function may not see it because:

a trigger(or a user defined plsql function that is referenced in this statement)
attempted to look at (or modify) a table was in the middle of being modified by the
statemnt which fired it.

- Was this comment helpful? Yes / No Reply - Report abuse

ashu2077 in Ballwin, Missouri

64 months ago

hello,
Judging for the information you have provided it sound like you are having a mutating table issue.
It would be best if you can post the code for detailed review.
Thanks

- Was this comment helpful? Yes / No Reply - Report abuse

deepakmannazhi in Kochi, India

48 months ago

Gilberto in Culiacán, Mexico said: When execute the trigger send this message

error during execution of trigger/function may not see it because:

a trigger(or a user defined plsql function that is referenced in this statement)
attempted to look at (or modify) a table was in the middle of being modified by the
statemnt which fired it.

hi,
to avoid mutation u can use pragma autonomous_transaction at the starting of the declaration section
regards
deepak

- Was this comment helpful? Yes / No Reply - Report abuse

» Sign in or create an account to comment on this topic.