Re: Passing entire row from trigger to stored procedure

From: Kurt Lee Harless <kurt.harless_at_allied.com>
Date: 1997/02/20
Message-ID: <330CBBB6.202D@allied.com>#1/1

Luis Pagan wrote:
>
> Is there a way to pass the entire row from a trigger to a stored
> procedure.
>
> ie
>
> create or replace trigger TIU_T_UNIFEEED
> before insert or update
> on T_UNIFEED
> for each row
> begin
> validate.process(:new);
> end;
>
> Currently, I am moving all the information I need to do validation into
> a user defined record type, and them moving any changed values back to
> the record before updating.
>
> Thanks for any help.
>
> Luis Pagan
> lpagan_at_mindspring.com

Luis,

If you get an answer to this, I would love to see it... Have a similar problem and have solved with a similar solution...

Too bad the :NEW structure doesn't allow dynamic resolution of the column names

Kurt Harless
AlliedSignal
Engine's DBA Group Received on Thu Feb 20 1997 - 00:00:00 CST