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: Tue, 06 Feb 2007 15:47:48 -0800
Message-ID: <1170805666.657982@bubbleator.drizzle.com>


prunoki wrote:
> Hello,
>
> Is there an elegant, easy way of passing the :new values of the row
> from an each row trigger to a procedure? (10g) A trigger or a
> procedure the trigger calls cannot read data from its own table (table
> is mutating error) so I need to pass the values as a parameter and I
> am looking for an easy way to do it. Basically to handle the :new row
> as a record variable (like table%rowtype) and pass it, without typing
> everything again (:new.field1, :new.field2, ...).
>
> I can generate the sql with select statements from cols of course. Or
> I could create a global temp or PL/SQL table. Anything more elegant?
>
> Any ideas,
>
> Krisztian
>

BEGIN
   myproc(:NEW);
END;
/

-- 
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 Tue Feb 06 2007 - 17:47:48 CST

Original text of this message

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