Re: CLOB SUPPORTED in Delphi 5/7 ADO ?

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.da-soft.com/

HTH,

Michael

"Graham Harris" <ng@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4334f718@xxxxxxxxxxxxxxxxxxxxxxxxx
> Jean-Michel Granier wrote:
>
> 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
>> 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 jmgranier@xxxxxxxxxx +33 (0)4 93 65 27
>> 86
>
>
>
> --
>


.

Relevant Pages