StackOverflow Questions for Tag: ora-04091

meha

Reputation: 25

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

oracle-databaseplsqltriggersora-04091

Score: 0

Answers: 2

Abhishek Nikam

Reputation: 11

ORA-04091 tableT is mutating, trigger/function may not see it

sqlplsqltriggersmutating-tableora-04091

Score: 1

Answers: 1

Ikenna

Reputation: 35

"ORA-04091 - Table "b" is mutating, trigger/function may not see it" when updating table "a" based on inserts, updates, and deletes from table "b"

sqloracle-databaseplsqltriggersora-04091

Score: 0

Answers: 1

skalluri

Reputation: 53

Oracle Trigger error - ORA-04091: table is mutating, trigger/function may not see it

oracle-databasetriggersora-04091

Score: 0

Answers: 1

L Mikhail

Reputation: 1

ORACLE TRIGGER WITH JOIN

oracle-databaseplsqltriggersora-04091

Score: -2

Answers: 1

Moonwar

Reputation: 43

I was trying to write a trigger but it gives Error like this in PL/SQL

oracle-databaseplsqltriggersora-04091

Score: 1

Answers: 0

Clyon97

Reputation: 59

BEFORE TRIGGER causes ORA-04091

sqloracle-databasetriggerssql-updateora-04091

Score: -1

Answers: 1

Bauerhof

Reputation: 165

ORA-04091 table is Mutating

oracle-databasetriggersmutating-tableora-04091

Score: 1

Answers: 1

mbk

Reputation: 1

ORA-04091 Error Keep two tables in sync using triggers

oracle-databasetriggersora-04091

Score: 0

Answers: 2

bebewr

Reputation: 126

How to use data from the updated table in a trigger?

sqloracle-databaseplsqldatabase-triggerora-04091

Score: 1

Answers: 1

5120bee

Reputation: 709

Trigger Compiles Fine But Encounters ORA-04091 on UPDATE

sqloracle-databaseplsqltriggersora-04091

Score: 1

Answers: 1

Shawn

Reputation: 7365

ORA-04091 - How can I alter a table that a trigger fires on?

sqloracle-databasetriggersora-04091

Score: 1

Answers: 3

Erik Hart

Reputation: 1354

Oracle Compound trigger - how to store and "use" deleted rows? INDEX BY table?

oracle-databasetriggersdelete-rowora-04091

Score: 3

Answers: 2

A.Istvan88

Reputation: 11

Trigger can not works - ora-04091 tabla is muting

ora-04091

Score: 1

Answers: 0

Paulo Santos

Reputation: 11587

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

oracle-databasetriggersora-04091

Score: 5

Answers: 2

kjpires

Reputation: 740

Translation of DB2 Trigger to Oracle triggers ORA-04091 Error

oracle-databasetriggersora-04091

Score: 0

Answers: 3

Ghojzilla

Reputation: 313

Oracle SQL setting single unique character

sqloracle-databasetriggersora-04091

Score: 0

Answers: 1

Sam

Reputation: 581

Delete rows matching substring with LIKE?

sqloracle-databasesql-likesql-deleteora-04091

Score: 2

Answers: 1

Paul Tomblin

Reputation: 182878

ORA-04091: table [blah] is mutating, trigger/function may not see it

oracle-databasehibernatetriggersora-04091

Score: 6

Answers: 4

Ragav

Reputation: 229

ora-04091 table is Mutating-

oracle-databaseora-04091

Score: 0

Answers: 2

PreviousPage 1Next

StackOverflow Questions for Tag: ora-04091

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

ORA-04091 tableT is mutating, trigger/function may not see it

&quot;ORA-04091 - Table &quot;b&quot; is mutating, trigger/function may not see it&quot; when updating table &quot;a&quot; based on inserts, updates, and deletes from table &quot;b&quot;

Oracle Trigger error - ORA-04091: table is mutating, trigger/function may not see it

ORACLE TRIGGER WITH JOIN

I was trying to write a trigger but it gives Error like this in PL/SQL

BEFORE TRIGGER causes ORA-04091

ORA-04091 table is Mutating

ORA-04091 Error Keep two tables in sync using triggers

How to use data from the updated table in a trigger?

Trigger Compiles Fine But Encounters ORA-04091 on UPDATE

ORA-04091 - How can I alter a table that a trigger fires on?

Oracle Compound trigger - how to store and &quot;use&quot; deleted rows? INDEX BY table?

Trigger can not works - ora-04091 tabla is muting

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

Translation of DB2 Trigger to Oracle triggers ORA-04091 Error

Oracle SQL setting single unique character

Delete rows matching substring with LIKE?

ORA-04091: table [blah] is mutating, trigger/function may not see it

ora-04091 table is Mutating-

"ORA-04091 - Table "b" is mutating, trigger/function may not see it" when updating table "a" based on inserts, updates, and deletes from table "b"

Oracle Compound trigger - how to store and "use" deleted rows? INDEX BY table?