Board index » delphi » Oracle CLOB ADO problem
Tue, 20 Sep 2005 06:58:32 GMT
Oracle CLOB ADO problem
Using ADO, I created a table in an Oracle database.
The table contains varchar2 types, number types, two CLOB fields. My
application runs against MS SQL, Oracle 8/9 and Access using ADO.
In my app, the CLOB fields are intended to be the Oracle version of MSSQL's
text and Access's memo field. Lot's of chars.
Well, I put some data in the field, say 200 chars. I then read it back.
It's corrupted. After the first 100 or so chars, the text seems to be
rearranged or something. (I am accessing the field ".asString")
Now, when I access the data using SQLPlus, (an Oracle tool) it is stored
I've seen some switches somewhere that have to do with "forcing retrieval of