tag:blogger.com,1999:blog-3747175925363126905.post8712816078582597789..comments2023-11-01T17:30:27.638+05:30Comments on Technology & Management Journal: How To Create a Database Level Audit (Trigger)?Anoop Saviohttp://www.blogger.com/profile/18084681245929178872noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3747175925363126905.post-61761939577041611452015-09-10T14:21:15.020+05:302015-09-10T14:21:15.020+05:30Hello Anonymous :)
Adding AUDIT_RECNAME is a strai...Hello Anonymous :)<br />Adding AUDIT_RECNAME is a straight forward process. Just add it to accompany the other 3 AUDIT fields and it works. Please see the last section of this post for the screenshot of AUDIT_RECNAME in action.Anoop Saviohttps://www.blogger.com/profile/18084681245929178872noreply@blogger.comtag:blogger.com,1999:blog-3747175925363126905.post-55997052717898212502015-09-09T23:26:02.272+05:302015-09-09T23:26:02.272+05:30Have you had any luck using AUDIT_RECNAME as part ...Have you had any luck using AUDIT_RECNAME as part of the Audit record? I would like to use this field since I have the same field name in 2 different records that I want to audit. I get an error when I create the trigger -- PLS-00049: bad bind variable 'OLD.AUDIT_RECNAME'.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3747175925363126905.post-91702438235745794002015-09-09T22:45:42.885+05:302015-09-09T22:45:42.885+05:30Very timely information since I'm creating a P...Very timely information since I'm creating a PSoft DB Trigger. I'm trying to use AUDIT_RECNAME in my audit file (just like PBooks says) but I get the following error: PLS-00049: bad bind variable 'OLD.AUDIT_RECNAME'. I want to use AUDIT_RECNAME since I need to audit changes to a field that is located in 2 different records. The audit/trigger works perfect if I don't Anonymousnoreply@blogger.com