Session context on Oracle, get active user language from code

Question

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.

Best answer by Dick van den Brink

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;
/

Dick van den Brink · Accepted Answer

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 · Answer

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

Sign up

Login to the Thinkwise Software Community

Scanning file for viruses.

This file cannot be downloaded