Calling a proc in a trigger

Hi,

I'm working on a table TABLE_TOP that has 2 columns: TOP, CODE. I've defined a trigger on it as followed:

TRIGGER TRG_TOP
AFTER UPDATE OF TOP ON TABLE_TOP
FOR EACH ROW
BEGIN
  PROC_TOP(:NEW.CODE);
END; The procedure that is called in the trigger need to access to the table TABLE_TOP: PROCEDURE proc_top(p_code in char) is
...

select count(*)
 into nb
 from TABLE_TOP
 where TOP = 'O'
 and CODE= p_code;
...

END; BUT... The following error has occurred:
ORA-04091: table TABLE_TOP is mutating, trigger/function may not see it

How can I solve that error ?
Is it impossible to access to a table in a trigger on that same table ?

Thanks for help. Received on Mon Jul 09 2001 - 03:42:28 CDT