How to Retrieve CLOB with ADODB Command Parameter (StoredProc), NOT by a Select statement

[Khodr]

Hi everyone,

I am calling an Oracle StoredProc that returns a CLOB data type value as an
output parameter. What parameter data type should I use?
if ADODB is not the right thing to use, so what is the right solution? and
how to use it?

Any help will be highly appreciated. Thanks.

Khodr

 

[David Browne]

Hi everyone,

I am calling an Oracle StoredProc that returns a CLOB data type value as
an
output parameter. What parameter data type should I use?

if ADODB is not the right thing to use, so what is the right solution?
and
how to use it?

ADODB is never the right thing to use. Use one of the oracle providers for
..NET.

here
http://www.oracle.com/technology/tech/windows/odpnet/index.html
you will find downloads and examples for CLOB and other oracle types.

David