ORACLE CLOBS IN ORACLE STORED PROCEDURE

From: tridib <tridib@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 28 Apr 2005 12:32:09 -0700

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
.

Follow-Ups:
- Re: ORACLE CLOBS IN ORACLE STORED PROCEDURE
  - From: Val Mazur \(MVP\)

Prev by Date: What data system can I use for storing documents?
Next by Date: Update database with a dataset
Previous by thread: What data system can I use for storing documents?
Next by thread: Re: ORACLE CLOBS IN ORACLE STORED PROCEDURE
Index(es):
- Date
- Thread

Relevant Pages

DBI-1.48 bind_param_inout produces ORA-01461 colliding with a CLOB
... can pass strings as varchar's and have them inserted ... In theory I could write something to query the ... CLOB w/in Oracle is probably what is killing me... ...
(perl.dbi.users)
Re: Oracle Text and searches across columns
... I haven't seen an Oracle Text example that handles this type of case. ... with a PL/SQL procedure that will aggregate all this data into a CLOB ... and present that to Oracle Text for indexing. ... DBMS_LOB.WRITEAPPEND(C, LENGTH(sBuf), sBuf); ...
(comp.databases.oracle.server)
RE: DBI-1.48 bind_param_inout produces ORA-01461 colliding with a CLOB
... into a clob. ... In theory I could write something to query the ... CLOB w/in Oracle is probably what is killing me... ... 'Activins are dimeric growth and differentiation factors which...', ...
(perl.dbi.users)
RE: DBI-1.48 bind_param_inout produces ORA-01461 colliding with a CLOB
... can pass strings as varchar's and have them inserted ... In theory I could write something to query the ... CLOB w/in Oracle is probably what is killing me... ...
(perl.dbi.users)
VB.NET passing CLOB input parameter to Oracle stored function
... I've included a posting from a couple years ago regarding passing a CLOB ... from VB.NET to an Oracle stored procedure. ...
(microsoft.public.dotnet.framework.adonet)