Very Urget Problem

[kanjeloup]

Alsalam 3alikom we ra7mat ALLAH we barakato
i have problem in multi language installation (Arabic,English)

description :
when am defining lookup with just 1 value (user type) and trying to get this value by value set depending on the lookup values table i found the value dublicated in the LOV , so i accessed the DataBase by Toad and issued the select statment as it is in value set , i found that there is 2 records one for (US) and another for (AR) .
and i can not use in my where (language = 'US') or (language = 'AR') , coz it will be hard coded , will never change depending on the language which am loggining by , as am defining differant description for each language ( 'Test' for US and 'اختبار' for AR) , so i have to get the proper value for each language .

Question :
how can i get the current language ?
i can imagin theres global variable or somthing like this holding the current language from the current session .
to can make my where like this (language = v_current_lang )

your response will be highly appreciated ..
thanks in advance .

Rania mahmoud
Oracle HRMS Consultant

[Sakher]

السلام عليكم،

I 'm not sure about the exact SQL that you are trying to run, since youy haven't posted. Anyway i hope the following sql will solve your problem, also you can get the ip of the user .

SELECT sys_CONTEXT('USERENV','LANGUAGE') ,sys_context('USERENV','nls_territory'),
sys_context('userenv','session_user')
from dual;

The NLS_TERRITORY will give you american or other currently used.

I hope this will solve the problem.

Thanks