Page 1 of 1

Problems with Unicode CLOBs

Posted: Thu 29 Mar 2007 00:54
by rmovchan
Hi,

I'm trying to use TOraLob objects to read and write Unicode CLOB data. When I write, I assign the AsWideString propery, say 'aaaaaa', which correctly sets the Size propery to 12 (the number of bytes). However when I read the same data and try to get the TOraLob.AsWideString, I get an OCI error, because it tries to read 0 bytes! Then I attempt to use the Read method with the Size of the CLOB as the number of bytes, and I get only half of my data. It appears that the Size property now returns the number of characters, not bytes (6 in the example)!

I'm using Oracle 10.2 and ODAC 5.55.

Thanks,
Roman

Posted: Thu 29 Mar 2007 11:09
by Plash
Please provide the Pascal code you are using.

Also supply us the following information
- exact version of ODAC including build number (see Oracle | About ODAC in IDE menu);
- exact version of Delphi, C++Builder or Kylix;
- exact version of Oracle server and client. You can see it in the Info sheet of TOraSession Editor.

Posted: Fri 30 Mar 2007 07:47
by rmovchan
Hello,

Thanks for your reply. Actually the problem has gone after I upgraded to ODAC 5.80. Sorry I should have done it before posting the complaint.

Thanks again,
Roman