Re: Checking if there has been a change

Hi Robert,

Can you use the trigger to write the rowid or primary key to a temporary table and then
use the temporary table to control access to the original table?

regards

Jerry

Robert Chung wrote in message <35ec6615.31572598_at_news.mindspring.com>...
>
>We have a rather complex PL/SQL batch code that processes entire table
>and update it. Due to the business logic, after the code updates a
>particular row, we need to visit that the same row again later and
>check if it has been changed before. This is done in the same
>transaction. Due to bureaucracy here, we cannot add another column to
>the table that we can mark whenever we make changes to the row.
>
>Triggers let you see before value and after value using :OLD and :NEW
>when you update something. We just need to know whether the row was
>modified before or not. Is there any way to find this out? Thank you
>in advance.
>
>
Received on Wed Sep 02 1998 - 07:08:14 CDT