Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Trouble with Triggers

Trouble with Triggers

From: abrusko <abrusko_at_binney-smith.com>
Date: Fri, 13 Aug 1999 03:37:44 -0800
Message-ID: <934544268.9023@www.remarq.com>


Hi,

I want to create a trigger that will write certain columns from a row in table "A" to a separate table whenever a row in table "A is deleted. It will act as a log and as a means of re-creating that record if needed at a later time.

I assume that this can be accomplished thru a trigger, but am having a little trouble in coding it. This is what I have so far...can someone please tell me what is wrong and how to correct it.



create or replace trigger copy_before_delete_freight before delete on frt.freight
for each row
begin
 Insert into frt.freight_deleted
 values(:old.frt_order, :old.bl, :old.accessorial_rc); end;

Thanks very much...Andy Received on Fri Aug 13 1999 - 06:37:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US