Trigger to log activity on tablename passed in
621560Feb 19 2009 — edited Feb 24 2009Hi Folks,
I want to write a trigger within a package when the user runs the package passing in the tablename a trigger for this table will monitor the activity on this table.
so when insert/update/del happens on the tablename it's recorded in an audit table for this tablename passed into the package.
I don't know the number of columns in the tablename however I will be adding extra columns in the audit table for the tablename passed in .
Any ideas how this can be done ???
anyone help would be much appreciated
Thanks
Edited by: user618557 on 19-Feb-2009 13:21