Possible to pass CLOB to Stored Procedure ?
360862Jan 30 2003 — edited Feb 4 2003Hello, All !
Just a Boolean question (Yes, No) for anybody knowing exact answer. We use Oracle 8.1.6 on Unix box, VB-6.0
(SP 4) with ADO 2.6 (MDAC 2.6). So I am wondering is that possible to pass big text/string (50K - 5MB) to CLOB datatype parameter in Stored Procedure via ADO to Oracle ?
It works with direct Table access and via Recordset but it doesn't work with SP ! I tried both Microsoft and Oracle OLEDB drivers but still getting an Error :
-2147217900
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'INSERT_CONFIGURATION_PRC'
PL/SQL: Statement ignored
I get this Error when ADO doesn't know how to interpret
parameter datatype. I tried this :
Set Parm = cmd.CreateParameter("iCONFIG_STRING", adLongVarChar, adParamInput, Len(ConfigString), ConfigString)
and this:
Set Parm = cmd.CreateParameter("iCONFIG_STRING", adVarChar, adParamInput, Len(ConfigString),
ConfigString)
Still Errors ...
So I am wondering is that doable at all ? (Maybe some later driver version can lift this issue ?)
If Yes - possible, please help (code samples are very helpful)
Thanx a lot !