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
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
--------------------------------------------------------------------