BI Publisher (MOSC)

MOSC Banner

See BI Publisher running report in v$session using JNDI datasource

edited Apr 13, 2015 10:01AM in BI Publisher (MOSC) 1 commentAnswered

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'.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center