Interested to Buy Any Domain ? << Click Here >> for more details...
how instead of triger is helpful for mutating tables errors
handlling ?
- 2 Answers
- 10737 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / guru
"Mutating" means "changing". A mutating table is a table
that is currently being modified by an update, delete, or
insert
statement. When a trigger tries to reference a table that is
in state of flux (being changed), it is considered
"mutating" and
raises an error since Oracle should not return data that has
not yet reached its final state.
Another way this error can occur is if the trigger has
statements to change the primary, foreign or unique key
columns of the
table off which it fires. If you must have triggers on
tables that have referential constraints, the workaround is
to enforce the
referential integrity through triggers as well.
There are several restrictions in Oracle regarding triggers:
• A row-level trigger cannot query or modify a
mutating table. (Of course, NEW and OLD still can be
accessed by the
trigger) .
• A statement-level trigger cannot query or modify a
mutating table if the trigger is fired as the result of a
CASCADE delete.
So some time we can not use triggers to put DMl operations
on table. that time we can use INSTEAD OF TRIGGER.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is a sql profiler?
Is pl sql useful?
Why is normalization important?
What is keys and its types?
What is difference between group by and partition by?
how to use like conditions? : Sql dba
What is row_number () in sql?
What are the packages in pl sql?
Where not exists in sql?
What is aggregate function in sql?
What program will open a mdb file?
how to load data files into tables with 'mysqlimport'? : Sql dba
how do you know the version of your mysql server? : Sql dba
What is plpgsql language?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
