Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Possible to pass CLOB to Stored Procedure ?

360862Jan 30 2003 — edited Feb 4 2003
Hello, 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 !
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2003
Added on Jan 30 2003
5 comments
587 views