Still my trigger!

From: barthon <developpement_at_cantoriel.fr>
Date: Thu, 3 Jun 1999 19:07:16 +0200
Message-ID: <7j6cpp$6pd$1@jaydee.iway.fr>

Hi,

I've got an other question about the triggers :

CREATE OR REPLACE TRIGGER test
BEFORE DELETE ON MY_TABLE
FOR EACH ROW
DECLARE
    i INTEGER;
BEGIN
    SELECT COUNT(*) INTO i
    FROM MY_TABLE;     INSERT INTO MY_TABLE_2
    VALUES(:OLD.My_row1,i);
END; I would like execute a statment "ON MY_TABLE" in my trigger AND get an old element.

Is it possible ?

Thank's for your answers.

JP Received on Thu Jun 03 1999 - 12:07:16 CDT