See BI Publisher running report in v$session using JNDI datasource
Hello,
I am trying to setup a pre-process function under Administration Data Sources for logging reasons.
In my function i.e. myfunc I use the following code:
DBMS_APPLICATION_INFO.SET_CLIENT_INFO(client_info=>'BIP User: '||p_user_name);
DBMS_SESSION.SET_IDENTIFIER(p_user_name);
When setting up myfunc as pre-process function for a JDBC connection a new session is created on the db and the column MODULE of v$session has also the name of the running report with a 'null' in front i.e. nullMyReport.xdo.
When trying to do the same for JNDI connection the column MODULE of v$session doesn't display the name of the running report but 'JDBC Thin Client'.