old value and new value

From: John Jones <john_at_iluvatar.tip.duke.edu>
Date: 1995/05/04
Message-ID: <Pine.NXT.3.90.950504082512.12711A_at_iluvatar>#1/1


  I know that you can use old.column and new.column in a trigger to compare updates, but can you use the same convention in a stored proc. We are trying to write a proc that will add records to a transaction log and need to compare if the values change for each column. Any body have any ideas or suggestions on this. Reply here or to e-mail.


John Jones			| my views are my own.........
Oracle Consultant		| no matter what company they are
john_at_iluvatar.tip.duke.edu	| coming from.

--------------------------------------------------------------------
Received on Thu May 04 1995 - 00:00:00 CEST

Original text of this message