mutant tables

[pak attack]

Hi!

In Oracle the solution for mutant tables is made two triggers,one for each row and other for each table.In version 5.0 triggers are only made for each row.How I solve this problem?Here there is an example of my problem:

CREATE TABLE DATE_TABLE1(
FIRST_DATE DATE,
LAST_DATE DATE
);

DELIMITTER |

CREATE TRIGGER AGE_OK AFTER INSERT ON DATE_TABLE1 FOR EACH ROW
BEGIN
IF NEW.FIRST_DATE > NEW.LAST_DATE THEN
DELETE FROM DATE_TABLE1 WHERE FIRST_DATE = NEW.FIRST_DATE AND
LAST_DATE=NEW.LAST_DATE;
END IF;
END
|


INSERT INTO DATE_TABLE1 VALUES (STR_TO_DATE('12/02/2004','%d/%m/%Y'),STR_TO_DATE('1/01/2000','%d/%m%Y'));

ERROR SAYS:

"CAN'T UPDATE TABLE 'DATE_TABLE1' IN STORED FUNCTION/TRIGGER BECAUSE IT IS ALREADY USED BY STATEMENT WHICH INVOKED THIS STORED FUNCTION/TRIGGER".

THANKS.