Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Fetching values in triggers
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.orgReceived on Thu Oct 12 2006 - 10:19:40 CDT