I am trying to write a generic (table independent) trigger for logging data changes on the column level - with very limited success. (Community server v5.5.34).
My research so far tells there is no way to access the NEW and OLD aliases without explicitly stating column names, since prepared statements are not allowed in triggers and referencing NEW/OLD as NEW.* or OLD.* results in an unknown table error.
Does anyone else know of any way to do this, or am I banging my head against an all too familiar wall?
Edited 1 time(s). Last edit at 06/15/2012 05:58AM by Dag Sondre Hansen.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.