Re: XMLType in Oracle and Delphi ADO components

From: Michael Jacobs (iq193_at_earthlink.net)
Date: 12/09/04

  • Next message: Brian Bushay TeamB: "Re: Access and Ado for multi-user" 
    Date: Wed, 8 Dec 2004 18:34:27 -0500

    Hi Ram,

      You cannot populate the XMLTYPE using ADO. The Oracle datatype doesn't
    correpsond to a defined ADO datatype.
      This is a limitation of ADO and applies to D7 as well.

    Yiu can always use a 3rd party component such as the Direct Oracle Access
    Components.

    Regards,

    Michael

    "Ram Mulay" <rammulay@hotmail.com> wrote in message
    news:41b75001@newsgroups.borland.com...
    > Hi all,
    >
    > Has anybody being able to populate an XMLType column on Oracle using the
    ADO
    > components in D6?
    >
    > I have tried all types of TFieldType with no luck. I keep getting the
    error
    > 'Parameter object is improperly defined. Inconsistent or incomplete
    > information was provided'.
    >
    > Thanks,
    >
    > Ram
    >
    >

  • Next message: Brian Bushay TeamB: "Re: Access and Ado for multi-user"

    Relevant Pages

    • Re: ADO.NET and ODBC { CALL ..... } Syntax
      ... > Coonecting to Oracle 8i DB running on Unix ... > OleDB connection with provider as MSDAORA. ... > the same way as it works in ADO arena. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: ADO.NET and ODBC { CALL ..... } Syntax
      ... > Coonecting to Oracle 8i DB running on Unix ... > OleDB connection with provider as MSDAORA. ... > the same way as it works in ADO arena. ... You should really only do this at design-time, or with a command you will ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Table open times and rowsize discontinuity
      ... some manner related to ADO or the tool you are using. ... Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text - ... For the array fetching, the only parameter I can find in the ADO ... exceeding the SDU and the MTU. ...
      (comp.databases.oracle.misc)
    • Re: :Oracle - Any advance on inserting CLOB to XMLTYPE?
      ... upload the CLOB ... I will look at the Lob locators and see if I can work it out with that later ... Oracle - Any advance on inserting CLOB to XMLTYPE? ...
      (perl.dbi.users)
    • Re: OO4O 2.1 vs MDAC
      ... We're planning to move VB3 using OO4O 2.1 ... Now I must distinguish and list out some of the features that ADO / ... (OLE DB or ODBC) ... Also you don't mention the Oracle version there are differences between ...
      (microsoft.public.data.ado)