Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Fetching values in triggers

Re: Fetching values in triggers

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 12 Oct 2006 08:19:40 -0700
Message-ID: <1160666376.449410@bubbleator.drizzle.com>


jaft wrote:
> Hi
>
> In a trigger for each row, is it possibile to fetch the old/new values
> of the current record in a pl/sql table, whose type is <table>%ROWTYPE?
>
> Thanks

Go to Morgan's Library at www.psoug.org
Click on Table Triggers
Scroll down to :NEW and :OLD
and run the demos

-- 
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 Thu Oct 12 2006 - 10:19:40 CDT

Original text of this message

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