Re: pass the row as a parameter from a trigger

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

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab