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