Re: Trigger novice needs help
From: Mark Grand <mdg_at_netcom22.netcom.com>
Date: 1995/08/03
Message-ID: <MDG.95Aug3071200_at_netcom22.netcom.com>#1/1
Date: 1995/08/03
Message-ID: <MDG.95Aug3071200_at_netcom22.netcom.com>#1/1
Oracle does not like FOR EACH ROW triggers to execute SELECTs on the table that the trigger is for. The trigger indicated below could be successfully rewritten by turning it into something like:
CREATE OR REPLACE TRIGGER trigger1
BEFORE DELETE ON table1
FOR EACH ROW
BEGIN
INSERT INTO table2 (column1, column2, ...) VALUES (:old.column1,:old.column2, ...);END; In article <3vpd9o$rkg_at_cheyenne.iac.net> mwagoner_at_iac.net (Mark Wagoner) writes:
>ORA-06512: at line 2
>ORA-04088: error during execution of trigger 'CHA.TRIGGER1'
>Here's what my trigger looks like...
>CREATE OR REPLACE TRIGGER trigger1
>BEFORE DELETE ON table1
>FOR EACH ROW
>BEGIN
> INSERT INTO table2
> (SELECT * FROM table1
> WHERE provider = :old.provider);
>END;
-- ============================== Mark GrandReceived on Thu Aug 03 1995 - 00:00:00 CEST