<< One message I am using a SELECT ... INTO .. FROM tablename WHERE CURRENT OF SYS_OLD. It seems to not like my where statement. >>
I believe that by the time you reach the AFTER UPDATE trigger, the SYS_OLD cursor is no longer available. If you want to journal your changes (and I have a number of applications that do this) you need to put the code in the BEFORE UPDATE trigger. -- Larry
