Type mismatch for field, expecting: WideString actual: Sting

jdorlon · Post by **jdorlon** » Mon 20 Jul 2009 19:21

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;

Challenger · Post by **Challenger** » Tue 21 Jul 2009 12:00

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.

jdorlon · Post by **jdorlon** » Wed 22 Jul 2009 15:22

Thank you. What can I change to my source to fix the problem, so I don't have to wait until the next version?

Challenger · Post by **Challenger** » Thu 23 Jul 2009 06:44

Please contact us by mail.