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


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 Grand
Received on Thu Aug 03 1995 - 00:00:00 CEST

Original text of this message