I have looked at the code you pointed me to, and have attempted to get it to work using a package, but I cant even get the package to compile..
Can you tell me what' s wrong with this? :
CREATE OR REPLACE PACKAGE BODY trigger_api AS
PROCEDURE tab1_row_change (p_numass IN varchar2,
p_datcre IN date) IS
INSERT INTO tempjob (numass, datecre) VALUES (p_numass, p_datcre);
PROCEDURE tab1_statement_change IS
FOR i IN (SELECT * FROM tempjob) LOOP
delete from passations where numass = i.numass and datcre = i.datcre;
DELETE FROM tempjob;
If I could at least compile, I could try and get to test if it works for me...
QUOTE (burleson @ Mar 10 2012, 12:33 AM)
>> Doing this process from code is not an option and MUST happen automatically via triggers.
The mutating trigger error can sometimes be avoided: