Re: How to Retrieve CLOB withADODB Command Parameter...? [message #36248] |
Tue, 13 November 2001 07:01 |
Ed
Messages: 24 Registered: November 1999
|
Junior Member |
|
|
Does anyone have a code sample that actually works?
I tried this and it fails repeatedly:
'start
Dim con As ADODB.Connection
Dim cmd As ADODB.Command
Dim sXml As String
Set con = New ADODB.Connection
con.Open "Provider=OraOLEDB.Oracle;data source=x;user id=x;password=x"
Set cmd = New ADODB.Command
With cmd
Set .ActiveConnection = con
.Properties("SPPrmsLOB") = True
.CommandText = "{ call xml_test.getDeal(?,?) }"
.CommandType = adCmdText
.Parameters.Append .CreateParameter("DealId", adInteger, adParamInput, 4, 1772)
.Parameters.Append .CreateParameter("Result", adLongVarChar, adParamOutput, 2048)
.Execute
sXml = .Parameters("Result").Value
End With
Set cmd = Nothing
con.Close
Set con = Nothing
'end
I have used different values for the data-type size of the return Parameter..it doesn't seem to make a difference...Each time the error is the same:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GETDEAL'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Thnx
----------------------------------------------------------------------
|
|
|
Re: How to Retrieve CLOB withADODB Command Parameter...? [message #36253 is a reply to message #36248] |
Tue, 13 November 2001 07:15 |
Ed
Messages: 24 Registered: November 1999
|
Junior Member |
|
|
Thanks for the quick response...I did try adNumeric as you suggested..but that didn't make a difference...
The prototype for the stored proc is as follows:
PROCEDURE getDeal(DealId IN NUMBER, Result OUT CLOB)
Dunno if this helps or not...
----------------------------------------------------------------------
|
|
|