Re: ORACLE CLOBS IN ORACLE STORED PROCEDURE
- From: "Val Mazur \(MVP\)" <group51a@xxxxxxxxxxx>
- Date: Thu, 28 Apr 2005 21:00:30 -0400
Hi,
If provider does not support CLOB (and this is what Microsoft says), then
you would need to use another provider (could be from Oracle) or ODBC
driver, but in a case of ODBC, ADO will use OLEDB for ODBC provider between
your ODBC driver and ADO. It will slow down the whole process (not
significantly) and could add additional issues
--
Val Mazur
Microsoft MVP
http://xport.mvps.org
"tridib" <tridib@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A33E29B5-C769-4CA5-A57C-71D3EED0DE87@xxxxxxxxxxxxxxxx
>I need to execute an ORACLE Stored Procedure, where I will send send an
> XML string as a CLOB input parameter, and receive a XML string as a CLOB
> output parameter.
>
> I am using ADO through VB6 to access the ORACLE SP.
>
> Do I need to use the ORACLE ODBC instead of the Microsoft one, which does
> not seem to support the CLOB type.
>
> --
> tridib
.
- References:
- ORACLE CLOBS IN ORACLE STORED PROCEDURE
- From: tridib
- ORACLE CLOBS IN ORACLE STORED PROCEDURE
- Prev by Date: Re: Update database with a dataset
- Next by Date: Re: What data system can I use for storing documents?
- Previous by thread: ORACLE CLOBS IN ORACLE STORED PROCEDURE
- Next by thread: Update database with a dataset
- Index(es):
Relevant Pages
|
|
