Re: Oracle Triggers - help required

tipu_at_systemsltd.com.pk (Tipu.) wrote in message news:<6f6ca778.0206050505.4e8186cb_at_posting.google.com>...
> 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

create or replace trigger mytable_biu
before insert or update on mytable
for each row
begin
  :new.salary := :new.salary + :new.commission;   :new.commission := 0;
end;
/ Received on Thu Jun 06 2002 - 05:23:20 CEST