I will prefer writing the trigger manually.. the only question is that I need to hardcode each column name in the trigger manually and finding solution for this hardcoding of columns..
I am with everything but stuck at getting old and new values. I have the name of column, whose value has changed, stored in the variable hence I cant access the values using :old.variable_name.... any solution for this ?
Hi kawa alkesh,
Did u done with your requirement. I also got the same requirement for that i need column name and old, new values dynamically through trigger for an audit purpose.
Edited by: user4487848 on Nov 20, 2012 2:55 AM