NLS_LANG Question
720700May 9 2011 — edited May 10 2011hi experts
in my application server (the embeded OC4J on my machine) i set the NLS_LANG in the regestry to
ARABIC_EGYPT.AR8MSWIN1256
and in my pre-form trigger i set the following
forms_ddl('ALTER SESSION SET NLS_LANGUAGE=AMERICAN');
forms_ddl('ALTER SESSION SET NLS_TERRITORY=AMERICA');
forms_ddl('ALTER SESSION SET NLS_DATE_LANGUAGE=AMERICAN');
forms_ddl('ALTER SESSION SET NLS_CALENDAR=GREGORIAN');
and in button on the form i display a message to get get_application_property(USER_NLS_LANG) and it return ARABIC_EGYPT.AR8MSWIN1256
and the statments in the pre-form trigger that set the NLS_LANG has no effects
i want to know if there exist something else other than forms_ddl('ALTER SESSION SET NLS_LANGUAGE=AMERICAN'); to change the NLS_LANG