By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,813 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,813 IT Pros & Developers. It's quick & easy.

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

P: n/a
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?
I tried adLongVarChar and adVarChar with the sizes 1000, 32000, 1000000 and they all fail. Size of returned value will exceed 50k. I know that there is a GetChunk, but I noticed that it applies only to SELECT statement. In my case, I have a StoredProc. I am using ADODB version 2.7
I am using VB.NET


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
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"Khodr" <kh******@excite.com> wrote in message
news:OI****************@TK2MSFTNGP10.phx.gbl...
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?
I tried adLongVarChar and adVarChar with the sizes 1000, 32000, 1000000 and they all fail. Size of returned value will exceed 50k. I know that there is a GetChunk, but I noticed that it applies only to SELECT statement. In my case, I have a StoredProc. I am using ADODB version 2.7
I am using VB.NET


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/tec...net/index.html
you will find downloads and examples for CLOB and other oracle types.

David

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.