CLOB SUPPORTED in Delphi 5/7 ADO ?

CLOB SUPPORTED in Delphi 5/7 ADO ?

Post by Jean-Miche » Sun, 25 Sep 2005 06:40:56


Hello there,

big problem

i need to query a table which contains a clob field.

The query hangs with : not supported field.

BDE runs the query fine.
Toad : OK
DBArtisan : OK

Oracle 9.2.1.0 version both client and server side
mdac 2.8
tried with mdac 2.7 and also ORacle 8.1.7.0 client.


What/where is the problem with CLOB and Delphi ???

Best regards.

Jean-Michel


PS'SOFT The IT Asset & Service Management Specialists Jean-Michel Granier
Chef de Produits "Le Berlioz" - 100, rue Albert Caquot 06410
Sophia-Antipolis/Biot - France XXXX@XXXXX.COM +33 (0)4 93 65 27 86
 
 
 

CLOB SUPPORTED in Delphi 5/7 ADO ?

Post by Graham Har » Sun, 25 Sep 2005 15:50:00


What is the query being used? Have (for example) writen the query
as

select clob_field from clob_table where value = : VALUE

Note the space after the parameter indicator. This could give you the
error you are talking about. to fix it just delete the space.

HTH

Graham Harris



--

 
 
 

CLOB SUPPORTED in Delphi 5/7 ADO ?

Post by Michael Ja » Mon, 26 Sep 2005 21:40:12

Yes. Oracle CLOBs can be problematic using Delphi and ADO. I've had success
when inserting data by specifying the datatype as 'ftMemo', but retrieveing
is a different issue and the 'datatype' returned by Oracle doesn't seem to
map to a datatype in ADO.

You might want to consider switching to NCOCI8 (free) for this application.
You can find it here: http://www.yqcomputer.com/

HTH,

Michael
 
 
 

CLOB SUPPORTED in Delphi 5/7 ADO ?

Post by Mick Boar » Tue, 27 Sep 2005 12:00:13

I've had success using with the Oracle's Provider for OLE DB but not
Microsoft's equivalent which doesn't seem to like CLOBs or BLOBs.

Regards,
Mick.