The :new and :old variables cannot be dynamically defined.
Getting column names from a table every time the trigger fires seems
to be an unnecessary overhead that has the potential to severely affect
performance. I don't recommend this approach. It is much more
efficient to specifically name each column in the trigger logic.
Regards,
Mike
Received on Thu Sep 03 1998 - 00:19:34 CDT