When the mutating error will comes? and how it will be
resolved?

Answer Posted / chandu

when we try to dml operation on orginal table in trigger.
then the trigger was excuted but while perfoming any action
on original table it will show mutating..

to overcome the above problem we need to create a autonamous
trasaction trigger..

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain clause in sql?

748


What is sql character function?

711


What is cold data?

678


How do you pronounce sql?

727


what are the advantages of mysql in comparison to oracle? : Sql dba

704






What are records give examples?

743


how to create a table index in mysql? : Sql dba

749


what does myisamchk do? : Sql dba

742


What port does sql server use?

709


discuss about myisam key cache. : Sql dba

763


How is pl sql different from sql?

726


what are the non-standard sql commands supported by 'mysql'? : Sql dba

774


What is the difference between left and left outer join?

690


What is the difference between unique and primary key constraints?

773


What is date functions?

729