无效的参数绑定参数名称 [英] invalid Parameter binding parameter name

问题描述

我收到错误的无效参数绑定参数名称.

我有需要调用多个来宾的Web服务.
在这里，我将一个通用列表中包含多个来宾，并且
将列表传递给refcursor 作为输入:

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:

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.

推荐答案

无效的参数绑定参数名称:...

输入数据流列类型与输出Oracle列类型不匹配 .使用标准的数据转换转换来设置正确的列类型.

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.

这篇关于无效的参数绑定参数名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！