Hi,
I need to use the new & old pseudo columns in a dynamic SQL & extract their values. The end user selects the columns of a table that need to be audited & the table contains many columns. Hence, in the after update trigger on the table - my column name is in a variable. So basically i need some means by which i can dereference the variable containing my column's name and use it along with the new & old pseudo record types to get the old value and the new value.
One way of doing this (I thought) is using execute immediate. But this does not work as the ':' means different things in the dynamic SQL world.
many thanks