refcursor
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
From link[^]: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.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)