Log all items in session state?
557616Jan 5 2010 — edited May 12 2010I need to create an error logging routine that captures an APEX user's current session state and dumps it into a log table.
I've already got the log table and an autonomous_transaction function defined in one of my pl/sql packages, but now I need to get the user's session info, e.g. what page they were on, what their app item values were, what the latest request was, etc.
Does anyone know of a way to do this without granting select on apex_030200.wwv_flow_data to the workspace id where the logging function exists?
Wwv_flow_data contains info for all users, I just want the log function to have access only to the current user/app/session data. Yes I can filter with a where clause, but I'd rather it be more like a self filtering view that shows you your own data (defined in the apex/flows schema). Better yet would be an APEX_UTIL function that returns session state in a clob or 32K varchar2 maybe even in name=value format!
My db version is 11.1 Enterprise with Apex 3.2.0.00.27.