Re: :NEW.RECORD?

From: Nils Petter Liadal <nils.petter.liadal_at_emmaedb.no>
Date: Fri, 19 Apr 2002 07:44:08 GMT
Message-ID: <cVPv8.2259$2E.69245@news2.ulv.nextra.no>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> skrev i melding news:cqutbuc582vodtfui3k6qgnthm7391ger3_at_4ax.com...
> On Thu, 18 Apr 2002 09:07:46 GMT, "Nils Petter Liadal"
> <nils.petter.liadal_at_emmaedb.no> wrote:
>
> >In a trigger; is it possible to access the entire record with something
like
> >:NEW.RECORD and :OLD.RECORD and assign it to a ROWTYPE-variable?
>
> NO
> They, don't exist.
>

OK, thank you.

If I want to bring :NEW.-data from an entire record into a procedure (as a parameter) called from a trigger, what would be the easiest way to do this?

<ROWTYPE-variable>.field1 = :NEW.field1;
<ROWTYPE-variable>.field2 = :NEW.field2;
<ROWTYPE-variable>.field3 = :NEW.field3;
.....

.....
.....
<ROWTYPE-variable>.field155 = :NEW.field155; theProcedureToCall(<ROWTYPE-variable>);

is kind of cumbersome. Is there an other, easier way?

Nils Petter Liadal
Trondheim/Norway Received on Fri Apr 19 2002 - 02:44:08 CDT