Can I create a trigger that loops the OLD and NEW values and compares the values and if they are different creates a change string as follows:
e.g; FOR EACH field IN NEW IF field.value <> OLD.field.name THEN changes := changes || field.name || ' was: ' || OLD.field.value || ' now is: ' || field.value || '\n\r'; END IF END FOR; Your help is really appreciated. Thank you.