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: pass the row as a parameter from a trigger

Re: pass the row as a parameter from a trigger

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 07 Feb 2007 08:33:53 -0800
Message-ID: <1170866031.709951@bubbleator.drizzle.com>


Serge Rielau wrote:
> sybrandb wrote:

>> Works like a charm if you generate the procedure from [user|all|dba|
>> _tab_columns, and if you generate a trigger in which you copy every
>> individual column to a record of r_client.
>> Hopefully you get the idea.

> I think the question was how to avoid copying every individual column.
> I.e form a language point of view it would make sense to allow :new as
> an argument to a procedure which has been defined to accept
> <triggersubjecttable>%ROWTYPE as a parameter.
>
> Cheers
> Serge

When is this new feature being implemented in DB2?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Feb 07 2007 - 10:33:53 CST

Original text of this message

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