Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Passing entire row from trigger to stored procedure
Luis Pagan <lpagan_at_mindspring.com> 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.
You probably already know you can't do the above.
Do you have to do validation on EVERY column? Maybe you could write some separate validation routines and pass only the columns you need. Received on Wed Feb 19 1997 - 00:00:00 CST