Direct mode fetches truncated column values

[a-s-z]

Hi,

we have a problem when using direct mode against 11G. Please check this issue as soon as possible!

Transcript for test case follows:

Code: Select all

create table odac_varchar_error ( text varchar2(10 char) )
/
insert into odac_varchar_error values ( '1234567890' )
/
select
  text||' 12345678#' a1, 
  length(text),
  dump(text||' 12345678#') a1_dump
from odac_varchar_error 
/

The select will result in a truncated value in direct mode here ("1234567890 1" instead of "1234567890 12345678#")! Oci mode seems to be ok.

Best Regards,
Andre

[AlexP]

Hello,

Please specify your ODAC and IDE versions, since this problem cannot be reproduced on the latest ODAC version 8.6.12.

[a-s-z]

Hello,

Please specify your ODAC and IDE versions, since this problem cannot be reproduced on the latest ODAC version 8.6.12.

We are using Odac 8.6.12 and Delphi XE2. Problem only exists when Session.Options.UseUnicode does not equal Session.Options.Direct. We are connecting to Oracle 11.2.0.3.0

Output of test program follows, I can provide test program if needed:

Code: Select all

DACProductName DACVersion: ODAC 8.6.12
============================================================
select
  text||' 12345678#' a1, 
  length(text),
  dump(text||' 12345678#') a1_dump
from odac_varchar_error
------------------------------------------------------------
OracleVersion: 11.2.0.3.0
Options.Direct: True
Options.UseUnicode: True
Fields[0]: "1234567890 1"
------------------------------------------------------------
------------------------------------------------------------
OracleVersion: 11.2.0.3.0
Options.Direct: True
Options.UseUnicode: False
Fields[0]: "1234567890 12345678#"
------------------------------------------------------------
------------------------------------------------------------
OracleVersion: 11.2.0.3.0
Options.Direct: False
Options.UseUnicode: True
Fields[0]: "1234567890 12345678#"
------------------------------------------------------------
------------------------------------------------------------
OracleVersion: 11.2.0.3.0
Options.Direct: False
Options.UseUnicode: False
Fields[0]: "1"
------------------------------------------------------------

Best Regards,
Andre

[AlexP]

Hello,

Thank you for the information, we have reproduced the problem and will try to fix it as soon as possible.

[a-s-z]

Hi Alex,

Thank you for the information, we have reproduced the problem and will try to fix it as soon as possible.

Thanks. Please provide code patch / direct mode dcu, if new odac version is not released soon. I can compile Odac locally.

Best Regards,
Andre

[AlexP]

Hello,

We have already fixed this problem. This fix will be included in the new version, that will be released next week.