Oracle Triggers - help required

Hello Every one
i am having a problem with oracle while writting trigger the error is mutating error
the senario is

Table name = mytable
fileds= userindx,username,userpass,salary,commition

i want for each update or insert in commition a trigger should be fired to do this

update salary = salary+commition and move zero(0) into commition i also tried using global temp database to insert values into that and then update form that table to this table can some one post the trigger script here ?

any one help meee Received on Wed Jun 05 2002 - 15:05:57 CEST