Re: ADO and ORACLE CLOB

From: Bernhard Geyer (Bernhard.Geyer_at_gmx.de)
Date: 07/13/04

  • Next message: Arnie Mauer: "Re: Strange problem" 
    Date: Tue, 13 Jul 2004 19:55:56 +0200

    Try native components like the components from CoreLab
    (http://www.crlab.com/products.html) or the ADO.NET-Driver from Oracle
    to get best support for all datatypes.

    I think the ADO-Driver for Oracle from Microsoft doesn't support all
    datatypes.

    JMG wrote:

    > Hello,
    >
    > we have a problem when quering tables with CLOB fields.
    > This is a simple select query, not an update query.
    >
    > in ADO/DELPHI 5, the query hangs with "unknown datatype" error.
    > in ADO .NET (C#) we have also problems to update but not to select...
    >
    > The same query in BDE/DELPHI 5 works properly.
    >
    > Have you ever seen this error with this datatype ?
    >
    > If you have any solution (in D7 maybe ...)
    >
    > Thank you.
    >
    > Jean-Michel
    >
    >

  • Next message: Arnie Mauer: "Re: Strange problem"

    Relevant Pages

    • Re: Definition of shape
      ... strange that a word that can't be defined is used so much in oracle app ... shape of prebuilt table does not match definition query ... table string and table string are not shape equivalent ... intuitively that the number of columns, the names, their datatypes ...
      (comp.databases.oracle.misc)
    • Re: Number or Decimal?
      ... Also, be advised, Oracle only has the NUMBER decimal type for storing ... SQL> select banner from v$version; ... PL/SQL Release 10.2.0.2.0 - Production ... supported non-Oracle datatypes and their mappings to Oracle datatypes. ...
      (comp.databases.oracle.misc)
    • How to insert a file in a CLOB field.
      ... I have to migrate a mysql table in a oracle table with the same ... structure (with the opportune conversions of the datatypes). ... I have read that in a CLOB I can insert 4GB. ...
      (comp.databases.oracle.misc)
    • Re: Persistent fields - ADO - Oracle database
      ... It seems that Oracle's been fiddling with their NUMBER datatypes. ... scale if a NUMBER datatype was created without specifying the scale. ... Client applications may rely on the previous behavior. ... upgrading to the next major release of the Oracle database. ...
      (borland.public.delphi.database.ado)
    • Re: How to insert a file in a CLOB field.
      ... I have to migrate a mysql table in a oracle table with the same ... structure (with the opportune conversions of the datatypes). ... I have read that in a CLOB I can insert 4GB. ...
      (comp.databases.oracle.misc)