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 -> Re: Trouble with Triggers

Re: Trouble with Triggers

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 15 Oct 2002 08:38:36 +0200
Message-ID: <kpdnqugdved4t48rlo5c0oqivfh1u8n9o7@4ax.com>


On Tue, 15 Oct 2002 04:51:00 GMT, "Schrödinger's Cat" <72446.2772_at_compuserve.com> wrote:

>TriggerStats after update on Trade for each row
>begin
> update Trade set column1 = column3 - column2;
> -- etc...
> -- column3 is new and column2 is old
> -- tried all sorts of variants: select :new.column3 - old:column2 into
>:new.column1 from DUAL; -- this required changing "after"
> --"before" :new.column1 := new.column3 - old:column2 ;
> -- also tried :new.column1 := new.column3 - old:column2 ;
>end;

need to change into

TriggerStats before update on Trade for each row

At least this is the appropiate syntax.
Not sure what you are upto and why you can't merge the trigger into the actual update.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Oct 15 2002 - 01:38:36 CDT

Original text of this message

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