Home » Developer & Programmer » Forms » character error in oracle forms / error nls lang (developer 10g)
character error in oracle forms / error nls lang [message #658635] Thu, 22 December 2016 04:31 Go to next message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
[MERGED by MC, and then by LF]



Dir sir ,
please , help me to solve this problem .
I installed Kurdi keyboard to write kurdish language . its look like arabic language .
when writing title in forms developer at design mode or when inserting data at run time mode
some characters (5 characters) appear error as ? or ... .
I used nls_lang=AMERICAN_AMERICA.AR8MSWIN1256
when I insert data into Notepad or MS Word all of it is fine without any problem .
thanks

[Updated on: Thu, 12 January 2017 13:57] by Moderator

Report message to a moderator

Re: character error in oracle forms [message #658637 is a reply to message #658635] Thu, 22 December 2016 05:44 Go to previous messageGo to next message
Michel Cadot
Messages: 67146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1/ And your database character set is?
2/ "nls_lang" is used for DOS applications, Windows ones use registry settings.

Re: character error in oracle forms [message #658639 is a reply to message #658637] Thu, 22 December 2016 06:16 Go to previous messageGo to next message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
its the same error in disktop application usnig 6i and web application using 10g
and the same problem while writing the title in both 6i and 10g at design mode .
Re: character error in oracle forms [message #658644 is a reply to message #658639] Thu, 22 December 2016 07:21 Go to previous messageGo to next message
Michel Cadot
Messages: 67146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
1/ And your database character set is?
Re: character error in oracle forms [message #658663 is a reply to message #658644] Thu, 22 December 2016 14:01 Go to previous messageGo to next message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
NAME                           SUBSTR(VALUE$,1,30)
------------------------------ ----------------------------
DICT.BASE                      2
DEFAULT_TEMP_TABLESPACE        TEMP
DBTIMEZONE                     -08:00
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               AR8MSWIN1256
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MM-YYYY
NLS_DATE_LANGUAGE              AMERICAN
NLS_SORT                       BINARY
NLS_TIME_FORMAT                HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY              $
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE
NLS_NCHAR_CHARACTERSET         AL16UTF16
*BlackSwan added {code} tags Please do so yourself in the future
How to use {code} tags and make your code easier to read

[Updated on: Thu, 22 December 2016 14:06] by Moderator

Report message to a moderator

Re: character error in oracle forms [message #658664 is a reply to message #658663] Thu, 22 December 2016 14:04 Go to previous messageGo to next message
Michel Cadot
Messages: 67146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is the query that gives you that?

Please read How to use [code] tags and make your code easier to read.

Re: character error in oracle forms [message #658665 is a reply to message #658663] Thu, 22 December 2016 14:05 Go to previous messageGo to next message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
the same error , I tested it in database 9 , 10g , 11 xe , but still the same error .
Re: character error in oracle forms [message #658666 is a reply to message #658665] Thu, 22 December 2016 14:06 Go to previous messageGo to next message
Michel Cadot
Messages: 67146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If the root is the same one, then it is logical to have the same error.

error nls lang [message #658760 is a reply to message #658635] Mon, 26 December 2016 06:28 Go to previous messageGo to next message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
Dir sir,
Please , help me , what nls_lang should I have to use in Arabic & Kurdish languages
when I writing it appear as ??? for some characters as : ط ذّ ظ ێ ؤ ث لآ
this error occurred in writing title of fields (prompt) and in writing into field into Database .
the Kurdish language same as Arabic language with some difference in 11 characters .
when I write using ms word or Notepad its ok without error .
I used AMERICAN_AMERICA.AR8MSWIN1256
AMERICAN_AMERICA.AL32UTF8
AMERICAN_AMERICA.AR8ASMO8X
AMERICAN_AMERICA.UTF8
AMERICAN_AMERICA.UTF16
And others , but still same error .
thanks
Re: error nls lang [message #658767 is a reply to message #658760] Mon, 26 December 2016 09:40 Go to previous messageGo to next message
Michel Cadot
Messages: 67146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It is useless to post again the same question without answering the previous topic the same answers will raise and the topic will end up in the same way.

I merge both topics to clearly show what I mean.

Re: error nls lang [message #658768 is a reply to message #658767] Mon, 26 December 2016 09:42 Go to previous messageGo to next message
Michel Cadot
Messages: 67146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Now you have to answer our questions if you want more help.

Re: error nls lang [message #658770 is a reply to message #658768] Mon, 26 December 2016 15:00 Go to previous messageGo to next message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
Dir sir ,
please, help me to find the solution of using suitable nls_lang .
the problem is not in the database or in query script .
the error occurred before connecting to database . as explained in attach document .
thanks

/forum/fa/13374/0/

[Updated on: Tue, 27 December 2016 00:23] by Moderator

Report message to a moderator

Re: error nls lang [message #658775 is a reply to message #658770] Mon, 26 December 2016 23:54 Go to previous messageGo to next message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
I hope my problem is clear to you and you can find the solution
thanks
Re: error nls lang [message #658782 is a reply to message #658770] Tue, 27 December 2016 01:15 Go to previous messageGo to next message
Michel Cadot
Messages: 67146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
the problem is not in the database
Prove this statement.

Re: error nls lang [message #658786 is a reply to message #658782] Tue, 27 December 2016 03:15 Go to previous messageGo to next message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
it is in both . in oracle forms 10g , 6i before and after connecting to DB .
and in DB . , I'm trying to insert into DB by using forms and SQL , but failed .
Re: error nls lang [message #658824 is a reply to message #658786] Wed, 28 December 2016 00:47 Go to previous messageGo to next message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
Dir sir ,
I still looking for solution , I hope you can help me .
thanks

[Updated on: Wed, 28 December 2016 00:48]

Report message to a moderator

Re: error nls lang [message #658868 is a reply to message #658824] Thu, 29 December 2016 01:03 Go to previous messageGo to next message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
Thanks , I find the solution , now its ok . as here :
1 - set database character set to utf8
connect "AS SYSDBA" in sqlplus.
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;
SHUTDOWN;
STARTUP RESTRICT;
SHUTDOWN;
STARTUP;

2 - set registry to both database and forms
nls_lang= AMERICAN_AMERICA.UTF8

regards
Re: error nls lang [message #658869 is a reply to message #658868] Thu, 29 December 2016 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 67146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1/ So the database WAS the problem, in the opposite to what you stated
2/ This is why I asked you, many times, for your database character set
3/ You have now skewed your database, feel very very very lucky if you have no problem in the future, you did it the wrong way, the worst way.

Re: error nls lang [message #658912 is a reply to message #658869] Fri, 30 December 2016 12:55 Go to previous messageGo to next message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
thank you sir ,
the problem still in forms 6i at design mode with nls_lang = AMERICAN_AMERICA.UTF8 , when I write title in
Kurdish character , the forms hang and closed . but at run time mode its OK . so in design mode I change nls_lang to AMERICAN_AMERICA.AR8MSWIN1256 .
so , please tell me if there is any error in DB setting .
thanks
Re: error nls lang [message #658959 is a reply to message #658912] Mon, 02 January 2017 05:51 Go to previous messageGo to next message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
Dir sir,
the problem still in the form .
the title and field prompt appear as rubbish character when use nls_lang = AMERICAN_AMERICA.UTF8
but db is write and retrieve is OK .
please if you have solution ?
Re: error nls lang [message #659051 is a reply to message #658959] Thu, 05 January 2017 03:06 Go to previous messageGo to next message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
Dir sir,
I still have error when connecting oracle forms 6i using nls_lang=utf8 with DB 11 character set = utf8
the canvas title and prompt and frame title are rubbish and it hang .
when useing forms 10g using nls_lang = utf8, al32utf8, al16utf16 , ar8mswin1256 , ... . whith db 11 utf8 : some characters still appear as ??? .
please help me .
is the oracle forms 6i patch 19 solve these problem ? from where can I download it ?
thanks
Re: error nls lang [message #659079 is a reply to message #659051] Thu, 05 January 2017 13:02 Go to previous messageGo to next message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
This is not a complete answer to your question as I do not have any experience with character sets, but I will tell you that I doubt patch 19 would solve the problem and that there is nowhere to download it as it has been desupported for over 15 year I think.
Now mind you, 6i will indeed connect to 11g and even 12c, and most functionality works, but something like character set conversion might be one of those things that it just cannot do.
oracle developer 10g hang using nls_lang=UTF8 [message #659317 is a reply to message #658635] Thu, 12 January 2017 10:52 Go to previous messageGo to next message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
Dir sir ,
Please, I use DB 11 , character set UTF8,
Oracle developer 10g , nls_lang = American_america.utf8
oracle developer hang and closed .
but its ok when using nls_lang=american_america.ar8mswin1256 , or other nls lang .
please if you can help me . itis necessary to me to use DB Character set = UTF8 to write kurdish characters.
thanks
Re: oracle developer 10g hang using nls_lang=UTF8 [message #659324 is a reply to message #659317] Thu, 12 January 2017 14:05 Go to previous messageGo to next message
Littlefoot
Messages: 21562
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There's no use in opening a new topic for the same problem; please, do not do that any more. It's now 3 topics we merged; that would be enough, I presume.

It's a pity you can not find the solution for that problem. Regarding Michel's message #658869, which is based on what you've done (and described) in a message #658868, your database is now in a useless state. Although I'm not a DBA and I do not have experience with different character sets nor NLS settings, I believe (simply by following discussions on the Internet) that you can't fix such things - if you can afford it, drop the database and create a brand new one, but this time using correct settings. Everything else seems to be waste of your (and our) time. Hopefully, someone else will be able to assist better than I can.
Re: oracle developer 10g hang using nls_lang=UTF8 [message #659381 is a reply to message #659324] Fri, 13 January 2017 14:16 Go to previous messageGo to next message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
Dir sir , I still looking for solution for this problem . any one please can help to solve this problem .
thanks
Re: oracle developer 10g hang using nls_lang=UTF8 [message #659457 is a reply to message #659381] Wed, 18 January 2017 05:42 Go to previous messageGo to next message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
Hi ,
Oracle forms 6i error when nls_lang = american_america.utf8 : title and prompt appear as rubbish character ,
oracle forms 10g : hang and closed when nls_lang = american_america.utf8 .
DB 11 , CHARACTER SET INTERNAL_USE UTF8
is there any one can help me to solve this problem ?
Re: oracle developer 10g hang using nls_lang=UTF8 [message #659464 is a reply to message #659457] Wed, 18 January 2017 08:10 Go to previous messageGo to next message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
What is the purpose of repeating the same question over and over. I am pretty sure people here are intelligent enough to be able to read the question the first time.
Re: oracle developer 10g hang using nls_lang=UTF8 [message #659564 is a reply to message #659464] Sun, 22 January 2017 06:36 Go to previous message
suh_sh
Messages: 22
Registered: January 2006
Location: Jordan
Junior Member
Dir sir , please, what to do if you still have the problem ? you are the expert !!
thanks .
Previous Topic: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508
Next Topic: set mouse navigation property to false
Goto Forum:
  


Current Time: Tue Jun 02 02:45:42 CDT 2020