Unicode paramter error

ysyang · Post by **ysyang** » Thu 04 Jun 2009 11:08

Hi

I use Delphi 2009,ODAC 6.80.0.47 and Oracle 9.0.1.1.1

Oracle Server Character Set : UTF8

TOrasesion.Option.Direct := True;
TOrasesion.Option.Charset := '';
TOrasesion.Option.Unicode := True;

I use the TSmartQuery component to query Unicode SQL

SQL)
Select * from all_object where object_name = '작업테이블'
=> Query success

but error does occur if use parameter

Sample Code:

procedure TForm11.FormCreate(Sender: TObject);
begin
OCIUnicode := True;
OraSession1.Connect;
end;

QTemp.SQL.Text := 'Select * from all_object where object_name = :obj';
QTemp.ParamByName('obj').DataType := ftString;
QTemp.ParamByName('obj').Value := '작업테이블';
QTemp.Open;

or
QTemp.SQL.Text := 'Select * from all_object where object_name = :obj';
QTemp.ParamByName('obj').DataType := ftString;
QTemp.ParamByName('obj').asString := '작업테이블';
QTemp.Open;

or
QTemp.SQL.Text := 'Select * from all_object where object_name = :obj';
QTemp.ParamByName('obj').DataType := ftWideString;
QTemp.ParamByName('obj'). Value := '작업테이블';
QTemp.Open;

error mesage is
ORA-01460: unimplemented or unreasonable conversion requested

--------------------------------------------------------------------------
same error does occur even if TOraSession.Options.CharSet = UTF8

Error does not occur if Oracle Server Character Set is AL32UTF8 or KO16MSWIN949 .

Error does not occur if TOraSession.Options.Direct=False

Thanks for any helep

Plash · Post by **Plash** » Tue 09 Jun 2009 07:46

We could not reproduce the problem. Please send to odac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.

ysyang · Post by **ysyang** » Fri 12 Jun 2009 00:31

The email send to you
Thanks!

ysyang · Post by **ysyang** » Mon 22 Jun 2009 08:56

Sample program attached to e-mail and i have not received a reply
Did you get email?

Plash · Post by **Plash** » Tue 23 Jun 2009 08:32

We have received your e-mail and we will look into it.

Ken · Post by **Ken** » Wed 24 Jun 2009 09:46

Same problem. Any update?

Plash · Post by **Plash** » Thu 25 Jun 2009 09:40

To Ken:

Please describe the steps to reproduce the problem.

azabluda · Post by **azabluda** » Thu 10 Sep 2009 14:50

Dear Plash,

We hit the same problem as ysyang in ODAC 6.8.0.50. In June you said that you're going to have a look at it. Any news?

Thanks,
Alexander

Plash · Post by **Plash** » Tue 15 Sep 2009 07:28

We have tested the problem using the sample project. But we could not reproduce the problem.

azabluda · Post by **azabluda** » Tue 15 Sep 2009 17:38

Sent you an e-mail
Created: Tue, 15 Sep 2009 19:34:07 +0200
Subject: Sample code for #14385 and #15010
Attachments: TestODAC.rar