Page 1 of 1

Type mismatch for field, expecting: WideString actual: Sting

Posted: Mon 20 Jul 2009 19:21
by jdorlon
Hello,

I am using the latest ODAC version with Delphi 2009.
Oracle server: 10.1.0.2
Oracle client: 11.1.0.6
OraCall.OCIUnicode := True;

When I create the following table and try to do a "select *" from it in TSmartQueryEx, I get this error:

Type mismatch for field 'SIGNATURE', expecting: WideString actual: Sting

CREATE OR REPLACE TYPE type_with_raws AS OBJECT
( signature RAW(2000))
/

create table has_type_with_raws
(col1 type_with_raws);

select * from has_type_with_raws;

Posted: Tue 21 Jul 2009 12:00
by Challenger
The RAW datatype in Oracle Type is always described as string now. We will fix this behavior to be compatible with single fields and VARCHAR datatype.

Posted: Wed 22 Jul 2009 15:22
by jdorlon
Thank you. What can I change to my source to fix the problem, so I don't have to wait until the next version?

Posted: Thu 23 Jul 2009 06:44
by Challenger
Please contact us by mail.