Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Trouble with Triggers
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
![]() |
![]() |