using oracle CLOB's in ADO
Posted on 2001-08-07
I'm trying to use Oracle stored procedures that either take or return the oracle CLOB data type, but when I try and execute the ADO command I get an error message saying the parameters are incorrect. Has anybody managed to successfully use CLOB's in VB at all?
The only documentation I've found says to set the following property on the command object:
.Properties("SPPrmsLOB") = True
but it still doesn't work.
If I try and refresh the parameters collection then I also receive an error (this only occurs when CLOBS are in the procedure declaration - if the procedure has no clobs then it works fine...)
I'm running ADO 2.5, VB6, Oracle 8.1.7
Any help appreciated...
Sorry - should have mentioned, I'm using the Oracle OLEDB provider (v126.96.36.199) rather than the microsoft one.