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

Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger, :old and :new record

Re: Trigger, :old and :new record

From: Tomm Carr <carr%tw_at_edwards.af.mil>
Date: 1997/09/02
Message-ID: <340C7C2C.5A61@edwards.af.mil>#1/1

Willy Klotz wrote:
>
> Is it possible to pass the :old and :new values in a trigger to a
> package ?

No. You may, of course, pass each field to the procedure (:new.field1, :new.field2, etc.), but OLD and NEW are not true row designators and cannot be used as such.

-- 
Tomm Carr
tommcatt@computer.org -- http://www.geocities.com/athens/delphi/6769
-- The Macintosh computer is like the open range;
-- In a world without fences, there are no Gates.
Received on Tue Sep 02 1997 - 00:00:00 CDT

Original text of this message

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