SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Mutating Trigger

HariharasudhanDec 13 2017 — edited Dec 13 2017

Hi All,

i am getting Mutating trigger error ( ORA-0491) while updating a table . interestingly the table does not have triggers . can someone share details why this is happening and what is the possible workaround ?

Db version = 12.1.0.2

update statement:

UPDATE dc_remedy_inbound ri

SET error_desc = error_desc || '-/-' || 'encounter_key Not Valid'

WHERE NOT EXISTS

(SELECT 1

FROM ir_encounter e

WHERE e.encounter_key = ri.encounter_key)

Error at line 62

ORA-12801: error signaled in parallel query server P006, instance es04dbadm03.uhc.com:irdst051 (1)

ORA-04091: table DC_USER.DC_REMEDY_INBOUND is mutating, trigger/function may not see it

regards

Hari.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 10 2018

Added on Dec 13 2017

20 comments

626 views