Error message is interrupted by Oracle direct connection

[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

[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.

[masakazu matsubara]

Hello,

I was able to successfully solve the problem.

It is used by "UseUnicode = True" .

Thank you.

[AlexP]

Hello,

Glad to see that the problem was solved. If you have any other questions, feel free to contact us.

[nkmt]

Hello,

After the upgrade, this phenomenon has occurred regardless of the　setting of Unicode.

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

[AlexP]

Try setting the UseUnicode and UnicodeEnvironment options to true :

Code: Select all

  UniConnection1.SpecificOptions.Values['UseUnicode'] := 'true';
  UniConnection1.SpecificOptions.Values['UnicodeEnvironment'] := 'true';

[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;

[AlexP]

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.