From: dewildeh@xs4all.nl (Henk de Wilde)
Subject: Re: Q:  How to pass record from a trigger?
Date: 1998/04/15
Message-ID: <3534f04c.49391126@news.xs4all.nl>#1/1
References: <35340F88.28D925F4@concentric.net>
X-XS4ALL-Date: Wed, 15 Apr 1998 23:00:50 CEST
Organization: XS4ALL, networking for the masses
Newsgroups: comp.databases.oracle.tools



On 14 Apr 1998 21:40:26 EDT, "J. A. Hallman" <hallman@concentric.net>
wrote:

>From within a before update trigger I would like to call a procedure
>passing :NEW and :OLD as parameters.  When attempting this I receive
>compile errors even the the procedure parameters are defined with
>%ROWTYPE.  Is there a way to pass the entire row with passing each
>individual field?
>
>Jeff
>hallman@concentric.net
>

In his book "Oracle8 PL/SQL Programming" Scott Urman states explicitly
that :new and :old are only syntactically records, but are implemented
as bindvariables, so that all the fieldvalues _have_ to be assigned
individualy. 

Disappointing, isn't it...

Sorry I couldn't help

Henk de Wilde.