Oracle 7 trigger error

Hi,

I have created the following trigger in Oracle 7.3:

create trigger add_user_and_date
after update or insert on frt.freight
for each row
begin
update frt.freight set
last_mdfy_emp = 'trigger',
last_mdfy_date =
  (select sysdate from dual);
end;

The trigger creates without any error.
When I fire the trigger thru an insert or update, I get the following error:
[INTERSOLV][ODBC Oracle driver][Oracle]ORA-04091: Table frt.freight is mutating, trigger/function may not see it ORA-06512: at "XXXX.ADD_USER_AND_DATE", line 2 ORA-04088: Error during execution of trigger 'XXXX.ADD_USER_AND_DATE' (#4091).

What would cause this error...thanks alot!!! Andy

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!