:) all,

     I am using row level trigger in which on updating the record, trigger is being fired. in updating condition within trigger i am using select statement which captures the count of records based on some condition. But the problem is i am getting mutating error while updating the record. why and when this happens.
can any one send sample examples on triggers

                thank you

please find a related discussion at http://asktom.oracle.com/tkyte/Mutate/index.html
and
http://www.dba-oracle.com/t_avoiding...able_error.htm

Regards
Debasis

A database trigger is procedural code that is automatically executed in response to certain events on a particular table in a database. Triggers can restrict access to specific data, perform logging, or audit data modifications.

A database trigger is procedural code that is automatically executed in response to certain events on a particular table in a database. Triggers can restrict access to specific data, perform logging, or audit data modifications.
==========================================
Victor
Our mission is to provide high quality end to end solutions to the BPO segment in a manner that will improve the operational efficiency while reducing the cost of the services to the client.
[email protected]