Re: Sending CLOBs to Oracle using VB/ADO

From: Ross McKay (rosko_at_zeta.NOT.THIS.BIT.org.au)
Date: 04/28/04


Date: Wed, 28 Apr 2004 00:32:54 GMT

On 27 Apr 2004 07:46:46 -0700, Tim Dale wrote:

>I have to pass some XML to an Oracle 8i stored procedure, which is
>expecting a CLOB, using VB and ADO.
>[snip]

Tim, if you have no luck with chasing this one down, maybe try RAW
instead of CLOB. IIRC, I needed to use RAW (or LONG RAW) for something I
did on Oracle back when MDAC 2.5 was the most recent version. It is
possible that either Oracle's or Microsoft's OLE-DB driver now supports
CLOB, but back then it did not and you needed to use RAW.

cheers,
Ross.

-- 
"There is more to life than simply increasing its speed." - Mahatma Gandhi


Relevant Pages

  • Re: Sending CLOBs to Oracle using VB/ADO
    ... > Tim, if you have no luck with chasing this one down, maybe try RAW ... I needed to use RAW for something I ... > CLOB, but back then it did not and you needed to use RAW. ... My connection string is generated by the following VB code: ...
    (microsoft.public.data.ado)
  • Re: Sending CLOBs to Oracle using VB/ADO
    ... > Tim, if you have no luck with chasing this one down, maybe try RAW ... I needed to use RAW for something I ... > CLOB, but back then it did not and you needed to use RAW. ... My connection string is generated by the following VB code: ...
    (microsoft.public.vb.database.ado)
  • Re: Sending CLOBs to Oracle using VB/ADO
    ... >expecting a CLOB, using VB and ADO. ... Tim, if you have no luck with chasing this one down, maybe try RAW ... IIRC, I needed to use RAW for something I ...
    (microsoft.public.vb.database.ado)
  • Re: How to transfer varchar2 to long raw
    ... Why LONG RAW? ... 100 characters, or maybe 5,000 characters long. ... Check out the Data Types page in Morgan's Library at www.psoug.org ... In my experience there is no interface that does not allow CLOB ...
    (comp.databases.oracle.misc)
  • Re: How to transfer varchar2 to long raw
    ... Why LONG RAW? ... In which version of Oracle? ... Blob or Clob will be better.But web developers use a interface to operate database. ... Check out the Data Types page in Morgan's Library at www.psoug.org ...
    (comp.databases.oracle.misc)