Re: CLOB SUPPORTED in Delphi 5/7 ADO ?

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.

"Michael Jacobs" <iq193@xxxxxxxxxxxxx> wrote in message
news:43369a44$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> 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

  • Re: Need Similar Oracle Query ?
    ... I am using Oracle 9i, ... Luqman ... >> I have created this query in Sql Server 2000 and I need to run similar ... >> Best Regards, ...
    (microsoft.public.vb.database.ado)
  • Re: Hunting got CPU Cost
    ... CPU and its cost for the query for which it is being utilized in ... Regards ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.server)
  • Query to export data from Access 2003 to Oracle ?
    ... How can I export data from Access 2003 to Oracle using Query? ... Best Regards, ... Luqman ...
    (microsoft.public.access.queries)
  • Re: Why is VARCHAR2(4000) bad ?
    ... CLOBs are SQL Standard. ... literals or VARCHAR2 variables into CLOBs, Oracle does implicit type ...
    (comp.databases.oracle.server)
  • Re: CLOB has me wishing for a new MDAC release
    ... included in MDAC 2.8 was developed against Oracle 7.1. ... One of my hands is tied by the fact that I'm using Crystal Reports to ... alter these CLOBs to Longs? ... That provider is just plain out of date. ...
    (microsoft.public.data.ado)