Top "Ora-04091" questions

mutating, trigger/function may not see it- error during execution of trigger

CREATE OR REPLACE TRIGGER UPDATE_TEST_280510 AFTER insert on TEST_TRNCOMPVISIT declare V_TRNCOMPNO NUMBER(10); CURSOR C1 IS SELECT B.…

sql oracle oracle9i ora-04091 ora-04088

Oracle After Delete Trigger... How to avoid Mutating Table (ORA-04091)?

Let's say we have the following table structures: documents docmentStatusHistory status +---------+ +--------------------+ +----------+ | docId | | docStatusHistoryId | | statusId | +---------+ +--------------------+ +----------+ | ... | | …

oracle triggers ora-04091