Click here to Skip to main content
15,892,298 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,
I am getting error invalid Parameter binding parameter name.

I have web service in which I need to invoke multiple guests.
In here, I am holding multiple guest in an generic list and
passing list to refcursor as input:
VB
param = New OracleParameter([Enum].GetName(typeParam, CompCheckIn.EnumCompleteCheckIn.p_guest_list), OracleDbType.RefCursor) 
param.Value = paramArrGuestList.ToArray (----> here i am passing list contain array of multiple guests <----)
param.Direction = ParameterDirection.Input
paramArr(indx) = param
indx = indx + 1
Private Function ExecuteDatasetOracleNonQuery(ByVal obj As Object) As Object
Dim iRslt As Integer
Try
newOracleCon.Open()
myOracleCMD = New Oracle.DataAccess.Client.OracleCommand
myOracleCMD.Connection = newOracleCon
myOracleCMD.CommandText = CType(obj, parameter).SPName
myOracleCMD.CommandType = CommandType.StoredProcedure
'myOracleCMD.ResetCommandTimeout()
Dim param As Oracle.DataAccess.Client.OracleParameter
'myCMD.Parameters.AddRange(paramArr)
For Each param In CType(obj, parameter).paramOracleArr
myOracleCMD.Parameters.Add(param)
Next
' Try
iRslt = myOracleCMD.ExecuteNonQuery() (---> here i am getting error as invalid Parameter binding parameter name )
newOracleCon.Close()
icnt = 0
Return CType(iRslt, Object)

Catch ex As Exception
newOracleCon.Close()
Throw ex
End Try
End Function

Please help me on this issue.

Thanks in advance.
Posted
Updated 17-Aug-10 22:43pm
v2
Comments
Simon_Whale 1-Sep-10 4:08am    
I personally would start by making sure the number and names of parameters are correct

1 solution

Invalid parameter binding Parameter name: ...

An input data flow column type doesn't match output Oracle column type. Use the standard Data Conversion Transformation to setup the proper column type.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900