Skip to Main Content
Forums

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NLS_DATE_LANGUAGE in NLS_LANG Parameter

RehmanJun 1 2010 — edited Jun 5 2010
Hi

My NLS_LANG = ARABIC_SAUDI ARABIA.AR8MSWIN1256
So when I take forms the default NLS_DATE_LANGUAGE is ARABIC. So the month in (DD-MON-YYYY) format appears as ARABIC. I want the month to come in English. I tried
FORMS_DDL(' ALTER SESSION SET NLS_DATE_LANGUAGE=''AMERICAN'' ');
:TXT_DATE := trunc(sysdate);
(TXT_DATE datatype: I tried DATE and CHAR - Oracle forms 10GREL2)

But still the month is displayed in ARABIC.

i searched in forum i found away to add the NLS_LANG in default.env file instead of adding in the O/S registry but in vein.

Any solutions?

Thanks & Regards
Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2010
Added on Jun 1 2010
#forms, #moved-from-devops
6 comments
2,542 views