Problem on trigger.

From: barthon <developpement_at_cantoriel.fr>
Date: Wed, 2 Jun 1999 19:29:34 +0200
Message-ID: <7j3pni$m8l$1@jaydee.iway.fr>

Hi,
Can somebody help me on this error:

CREATE OR REPLACE TRIGGER test
BEFORE DELETE ON MY_TABLE
FOR EACH ROW
DECLARE
    i INTEGER;
BEGIN
    SELECT COUNT(*) INTO i
    FROM MY_TABLE;     DBMS_OUTPUT.PUT_LINE(i);
END; If the SQL statement
DELETE FROM MY_TABLE WHERE My_row1 = 'A'; is issued, an error is returned:
"MY_TABLE is mutating..."

I'm looking for an other method to execute an SQL statement on "MY_TABLE" in a trigger "ON MY_TABLE".

Thanks for your answers.

JP Received on Wed Jun 02 1999 - 12:29:34 CDT