Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Trigger, :old and :new record
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.deReceived on Sat Aug 30 1997 - 00:00:00 CDT
======================================================================