使用Oracle. manageddataaccess . client调用Oracle存储过程时，参数顺序不正确

我正在使用最新的Oracle. manageddataaccess . client 11.2 .dll从Oracle到。net应用程序获取数据。是否需要按照存储过程所期望的顺序传递参数?

从应用程序端我们添加参数顺序命令对象cmd是

KK_C
KK_C2
KK_C1

类似

的存储过程

KK_C
KK_C1
KK_C2

这是通用代码，我不能传递与存储过程期望的相同顺序的参数。因为不同的存储过程需要不同的参数顺序

我的方法:

Public Function GetDataTable(ByRef xmlParams As XmlNodeList) As DataTable
{
     Dim param As OracleParameter
     Dim params As List(Of OracleParameter) = New List(Of OracleParameter)()
     For Each node As XmlNode In xmlParams
param = New OracleParameter()
param.ParameterName = Convert.ToString(node.SelectSingleNode("name").InnerText)
param.OracleDbType = CType("112", OracleDbType)
 param.Value =Convert.ToString(node.SelectSingleNode("name").InnerText)

   Next
 Dim addparam As OracleParameter
            Dim cmd As OracleCommand
            Dim objdt As DataTable
            OpenConnection()
            cmd = New OracleCommand()           
            cmd.Connection = _oracleConn            
            cmd.CommandText = sql           
            cmd.CommandType = CommandType.StoredProcedure           
            If Not params Is Nothing Then
                For Each param As OracleParameter In params             
                    addparam = New OracleParameter()
                    With addparam                   
                        .Direction = param.Direction
                        .OracleDbType = param.OracleDbType 
                        If Left(param.ParameterName, 2) <> "KK_" Then
                            .ParameterName = "KK_" & param.ParameterName
                        Else
                            .ParameterName = param.ParameterName
                        End If
                        .Size = param.Size
                        .Value = param.Value
                    End With
                    cmd.Parameters.Add(addparam)
                Next
            End If
            addparam = New OracleParameter("OO_remcursor", OracleDbType.RefCursor)
            addparam.Direction = ParameterDirection.Output
            cmd.Parameters.Add(addparam)
            'fill the datatable
            objdt = New DataTable(tblname)
            Using objda As New OracleDataAdapter(cmd)
                objda.Fill(objdt)
            End Using
            Return objdt
}

存储过程:

PROCEDURE GetDATA(KK_C IN NUMBER,KK_C1 IN NUMBER, KK_C2 IN NUMBER OO_remCursor OUT o_Cursor)
    AS
    BEGIN
        OPEN o_remCursor FOR
        SELECT ....        ORDER BY LOWER(brand_alias);
    END GetDATA;

cmd.BindByName = True