This content has been marked as final. Show 21 replies
FormsEleven wrote:Correct, but problem is I created a form and tried it but it has NO effect. I even make this property at canvas level to R-2-L. Still no luck.
There is something called Direction in the Form Module properties. You can change that to RTL.
Of course you also need to change the Language setting s..
Do I HAVE to change nls_language to PERSIAN for this to take effect?
Forms help is of no use.
Edited by: Channa on Jan 4, 2011 4:18 AM
why do we have to set nls_lang to Arabic? Can't we set it to PERSIAN also?i gave u just an example but off course u have 2 change it to urs PERSIAN but i don't know urs ;)
what it is most important to note here is the UTF8 on the right hand side & it could be also AR8MSWIN1256 for arabic languages
and off course this will work for Right to Left Languages ;
Look above (i.e. Arabic style)
it works for me :)
N.B._ changing the Default Language Windows > Regional Settings also affects the direction of the Form module and the direction of the text's prompt Only in Design Time_
But in Run time the Nls_Lang has the periority's affection on form's Direction and the whole staff but the Data it's whole about Oracle's instillation...
u may also need to change ur db language if u didn't consider that as FormsEleven Suggest.
Edited by: Abdetu on Jan 5, 2011 12:05 AM
you have to modify the registry for language and for this you have to set NLS_LANG for all oracle homes.
as Abdetu mentioned in his/her post.
u may also need to change ur db language if u didn't consider that as FormsEleven Suggest
and if you update the db maybe your database will be corrupt or maybe you will get problem,updation is not a good idea.
Edited by: QGIR on Jan 4, 2011 11:27 PM
The Name as mentioned makes me admitted & imagined how the minor i am to the whole world that is created by God included my eyes,thinking ,finger's typings ...
am alllll ,we allll belongs to him his majesty
So every thing i do...
i do with his authority and permission so why i am not Abdetu...
Edited by: Abdetu on Jan 4, 2011 11:42 PM
I tried everything you guys said but no luck. I changed the lang and calendar for the session since I don't have DBA access to the DB. Please see the picture below with actual results.
Even changing Regedit NLS_LANG has no affect.
Still I cannot type like in Arabic. i.e. from Right-to-Left.
Also, you CANNOT set NLS_LANGUAGE to PERSIAN. You can only set it to Arabic. Why is this? So, becuase of this will Iranians will be NOT be able to store data in Persian???
+DEFINE _DATE = "15 Dei 1389" (CHAR)+
+DEFINE CONNECTIDENTIFIER = "ava453dv_tpng" (CHAR)+
+DEFINE _USER = "ABS" (CHAR)+
+DEFINE _PRIVILEGE = "" (CHAR)+
+DEFINE SQLPLUSRELEASE = "1001000402" (CHAR)+
+DEFINE _EDITOR = "Notepad" (CHAR)+
+DEFINE OVERSION = "Oracle Database 10g Release 10.2.0.3.0 - Production" (CHAR)+
+DEFINE ORELEASE = "1002000300" (CHAR)+
+DEFINE _RC = "1" (CHAR)+
+ABS@ava453dv_tpng>ALTER SESSION SET nls_language= PERSIAN ;+
ORA-12705: Cannot access NLS data files or invalid environment specified+
Wrote file afiedt.buf
+1* ALTER SESSION SET nls_language=ARABIC+
Edited by: Channa on Jan 5, 2011 2:11 AM