[QUOTE][i]Originally posted by puneet [/i]
[B]Hi

Create or replace trigger order_hist
before insert or update of ORPSTMP,ORUSTMP,ORSTAT on orders
for each statement
begin
insert into RF_ORD_HIST
select orrfnbr,orstat,ORUSTMP from orders;
commit;
end;
/


I am getting a table mutatiion here. Let me know what to do . Will declaring teh variables help me here

Let me know [/B][/QUOTE]

1. If you wouldn't get table-mutating error, you would get some other ORA message telling you that you can't use COMMIT or ROLLBACK insde a trigger (unles you would implement it as autonomus transaction).

2. There is something wrong with the logic of your trigger. Before any insert statement you are trying to save some column values from *all* of the rows of your triggering table (you have no WHERE clause!) - is this realy what you want to do?