Page 1 of 1
Error message is interrupted by Oracle direct connection
Posted: Sun 25 Aug 2013 01:12
by masakazu matsubara
Hello,
Error message is interrupted by Oracle direct connection in an
environment of "NLS_LANGUAGE = 'JAPANESE'".
SQL : select 1/0 from dual
Actual message : ORA-01476: 除数がゼ
Expected message: ORA-01476: 除数がゼロです
Is there a solution? .
It becomes normal to "UseUnicode = True", but additional problems.
UniDAC 5.0.2
Delphi XE2
Oracle 11g Express Edition Release 11.2.0.2.0
Re: Error message is interrupted by Oracle direct connection
Posted: Tue 27 Aug 2013 09:32
by AlexP
Hello,
To get a correct error message, you should set the OciUnicode variable (declared in the OraCallUni module) to True before connecting to the server.
Re: Error message is interrupted by Oracle direct connection
Posted: Wed 28 Aug 2013 00:23
by masakazu matsubara
Hello,
I was able to successfully solve the problem.
It is used by "UseUnicode = True" .
Thank you.
Re: Error message is interrupted by Oracle direct connection
Posted: Wed 28 Aug 2013 05:27
by AlexP
Hello,
Glad to see that the problem was solved. If you have any other questions, feel free to contact us.
Re: Error message is interrupted by Oracle direct connection
Posted: Wed 16 Jul 2014 07:18
by nkmt
Hello,
After the upgrade, this phenomenon has occurred regardless of the setting of Unicode.
masakazu matsubara wrote:
SQL : select 1/0 from dual
Actual message : ORA-01476: 除数がゼ
Expected message: ORA-01476: 除数がゼロです
I'm sure in the following versions.
UniDAC 4.6.12 : not occur.
UniDAC 5.2.5 : occur!
Delphi XE2
Oracle 11g Release 11.2.0.1.0
Re: Error message is interrupted by Oracle direct connection
Posted: Fri 18 Jul 2014 10:15
by AlexP
Try setting the UseUnicode and UnicodeEnvironment options to true :
Code: Select all
UniConnection1.SpecificOptions.Values['UseUnicode'] := 'true';
UniConnection1.SpecificOptions.Values['UnicodeEnvironment'] := 'true';
Re: Error message is interrupted by Oracle direct connection
Posted: Tue 22 Jul 2014 01:21
by nkmt
Hello,
Thank you for reply.
I was able to resolve the problem.
Charset of the DB is not Unicode, but I decided to set Unicode to true.
For now, Select, Update, Insert seems to be going well.
It seems to be all right even if Charset options match Charset of db.
Code: Select all
UniConnection1.SpecificOptions.Values['UseUnicode'] := 'true';
UniConnection1.SpecificOptions.Values['UnicodeEnvironment'] := 'true';
UniConnection1.SpecificOptions.Values['Oracle.Charset'] := 'JA16SJISTILDE';
initializaiton
OCIUnicode = True;
Re: Error message is interrupted by Oracle direct connection
Posted: Tue 22 Jul 2014 07:17
by AlexP
Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.