Re: Help on TRIGGER!!!!
From: Nazareno Barbieri <bbsistemi_at_tecna.it>
Date: 1997/10/12
Message-ID: <34416048.8B8_at_tecna.it>#1/1
Date: 1997/10/12
Message-ID: <34416048.8B8_at_tecna.it>#1/1
Referenced tables are in mutating status until FOR EACH ROW trigger
terminates;
I solved this writing a package containing a PL/SQL table into which
saving all sql statements: in the AFTER STATEMENT trigger, when mutating
status is removed, I proceed to execute all statements previously saved
(using DBMS_SQL package).
N.Barbieri
B&B sistemi
Received on Sun Oct 12 1997 - 00:00:00 CEST