Skip to main content
Question

Session context on Oracle, get active user language from code

  • January 13, 2026
  • 2 replies
  • 43 views

Theo Neeskens
Vanguard
Forum|alt.badge.img+2

Ayvens is building multi-lingual applications with Thinkwise on Oracle.
These applications do are not just multi-lingual for menu's, labels etc but also have multi-lingual data.
To implement that, they need to get the current user's active language from code.

When running Thinkwise on MS SQL Server you can get the user's active language with:
select SESSION_CONTEXT(N'tsf_appl_lang_id');

When running Thinkwise on Oracle I would expect to be able to use:
select value from session_context where namespace = '?dont know?’ and ATTRIBUTE = ‘TSF_APPL_LANG_ID’;

But Thinkwise does not set session context on Oracle…

Please add the setting of session context to the Oracle implementation of the Thnikwise platform.

2 replies

Forum|alt.badge.img+3

Hi Theo,
I believe we do set session variables on Oracle but Indicium needs rights to set them. I am not an Oracle expert but it is something like this:
 

alter session set current_schema = your_schema_name;
/
create or replace context session_vars using tsf_set_session_variable;
/

Theo Neeskens
Vanguard
Forum|alt.badge.img+2
  • Author
  • Vanguard
  • January 13, 2026

I now see this in the Thinkwise documentation. I do not have the rights, will try it when I can get time of the Oracle DBA,

“Furthermore, a new procedure (tsf_set_session_variable) has been added to the generation process of Oracle databases to support the use of session variables by Indicium for Oracle. This procedure needs to be applied at least once after the upgrade to 2022.2.”