SQL Language (MOSC)

MOSC Banner

Parameter CLIENT_IDETIFIER is NULL whereas we got a literal value a few days ago

edited Nov 20, 2024 12:42PM in SQL Language (MOSC) 4 commentsAnswered ✓

We used the parameter CLIENT_IDENTIFIER in our applications logic for logging and security issues. This parameter is described in

But suddenly, it has stopped working and next query returns NULL value:

SELECT SYS_CONTEXT ('USERENV', 'CLIENT_IDENTIFIER') FROM DUAL;

It doesn't matter if it's executed in SQL Developer, sqlplus, java application or whatever, always return NULL now.

Do you know the explanation for this change of behaviour and how can we go back to previous situation?

NOTE:

In the meanwhile, we have found a workaround using this other query:

select substr(program, 1, 30) from v$session where audsid = SYS_CONTEXT('USERENV','sessionid');

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