Mutation of triggers

[rohandeshmukh1983]

Hi,

I've a table in which I'm suppose to control value of one column col1 based on another column col2. i.e. if col2 is updated, col1 should get updated based on new value of col2. Also, this operation is to be executed only in case value of col3 has
particular value.

I wrote a trigger 'after update' for each row and verified the value for col3. also i checked that the value of col2 is changing.

when, in the trigger I wrote update statement for the same table, it gives me the table mutation error. Please tell me how should i implement this functionality.

- Rohan

[debasisdas]

please find related discussions at

http://asktom.oracle.com/tkyte/Mutate/index.html