How to Pass APP_USER to a database trigger for auditing
1026247Jun 6 2013 — edited Jun 6 2013I have a table which is updated by an Apex Page. (Application Express 4.2.1.00.08).
The application is using the standard Oracle apex authentication.
I have created an Audit table with a before update trigger to insert a record into the audit table of who made a change to what column and when.
If I use User in the trigger I get APEX_PUBLIC_USER recorded as who changed the record.
What I actually need is the APP_USER Value e.g KJR recorded. I am not writing the APP_USER to a field in the table so I cannot use : new syntax to capture it from any of the field I am updating.
Can anyone advise how I can pass the APP_USER for the trigger to use?