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 -> Trigger, :old and :new record

Trigger, :old and :new record

From: Willy Klotz <willyk_at_t-online.de>
Date: 1997/08/30
Message-ID: <5u9bdg$r6l$1@news02.btx.dtag.de>#1/1

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

What I try to do is to pass the whole record, something like

create trigger bi_table

before insert on table

on every row

begin

  in_package.do_something (:new.*);

end;

package in_package is

procedure do_something (newrecord table%rowtype);

...

The syntax in calling the package ('new.*') is not correct; anyone know the correct syntax ? Or is this not possible ?

Willy Klotz

Willy Klotz


Willys Mail     FidoNet   2:2474/417  2:2474/418  
                Mailbox: analog 06297 95035
                         ISDN   06297 910105
                Internet: willyk_at_t-online.de                

======================================================================
Received on Sat Aug 30 1997 - 00:00:00 CDT

Original text of this message

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