> 1. What is Mutating Table Error ? How to Solve it ?
One possible cause is when you performing an activity on a table (ie.table1)
that activates its trigger which cantains an insert/update/delete statement
in another table (ie. table2), and table1 has a foreign key in table2. As
far as I know this only occurs in Oracle dbms.
Solution: remove referential integrity between these tables or move
functionality located in the trigger somewhere else.
Regards
Jarek
-- Jarek Mosiejewski
>> [EMAIL PROTECTED]
>>ICQ: 5670752
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]