Page 1 of 1
Direct mode fetches truncated column values
Posted: Mon 08 Apr 2013 15:05
by 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
Re: Direct mode fetches truncated column values
Posted: Tue 09 Apr 2013 11:28
by AlexP
Hello,
Please specify your ODAC and IDE versions, since this problem cannot be reproduced on the latest ODAC version 8.6.12.
Re: Direct mode fetches truncated column values
Posted: Tue 09 Apr 2013 14:17
by a-s-z
AlexP wrote: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
Re: Direct mode fetches truncated column values
Posted: Wed 10 Apr 2013 10:00
by AlexP
Hello,
Thank you for the information, we have reproduced the problem and will try to fix it as soon as possible.
Re: Direct mode fetches truncated column values
Posted: Wed 10 Apr 2013 10:15
by a-s-z
Hi Alex,
AlexP wrote: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
Re: Direct mode fetches truncated column values
Posted: Wed 17 Apr 2013 10:14
by AlexP
Hello,
We have already fixed this problem. This fix will be included in the new version, that will be released next week.