紧急请任何人在程序调用中帮助解决异常错误的数量或类型的参数 [英] Urgent Please can anybody help to resolve exception wrong number or types of arguments in call of Procedure

问题描述

我有以下代码用于导入文件，但在线

I have below code for Import a file ,but on line

int recordsInserted = o_Cls_OracleConnect.CallStoredProcedure("IMP_PKG.BANKMSTIMP");
                  o_Cls_OracleConnect.Dispose();

它给我以下例外

it gives me below exception

ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'BANKMSTIMP'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

if (imp_module == "m_impbankmaster")
{
    //Call Procedure
    try
    {
        s_dsnstr = o_Cls_Utility.utl_fnGetDSNStr(SessionCheck.s_sessiondpid);
        OracleConnect o_Cls_OracleConnect = new OracleConnect(s_dsnstr);
        o_Cls_OracleConnect.CallStoredProcedure_PreInit();
        o_Cls_OracleConnect.CallStoredProcedure_Varchar2_AddParameters("Par2", parameter2);
        o_Cls_OracleConnect.CallStoredProcedure_Varchar2_AddParameters("Par3", parameter3);
        o_Cls_OracleConnect.CallStoredProcedure_Varchar2_AddParameters("Par4", parameter4);
        int recordsInserted = o_Cls_OracleConnect.CallStoredProcedure("IMP_PKG.BANKMSTIMP");
        o_Cls_OracleConnect.Dispose();
    }
    catch (Exception ex)
    {
        throw ex;
    }
}

以下是商店程序。

Below is Store Procedure.

Case 8  'Bank Master
          Par2 = aArr(1)  'Path
          Par3 = aArr(2)  'File Name
          Par4 = aArr(3)  'User Id
          conn.Open dsn 'Establishing Connection with Server
          conn.BeginTrans
          On Error GoTo ErrTrap:
          SQL = " Begin " & _
                " imp_pkg.BankMstImp('" & Par2 & "','" & Par3 & "','" & Par4 & "'); " & _
                " End; "
          conn.Execute SQL
          conn.CommitTrans
          Label1.Caption = "Bank Master Import - CD10 has completed."

以下是商店程序。

Below is Store Procedure.

CREATE OR REPLACE PROCEDURE imp_pkg.BankMstImp(cPath VARCHAR2,cFilename VARCHAR2,cUserName VARCHAR2) AS

推荐答案

我想我知道你的是什么问题是。

参数化是基于zerobased但你的第一个参数（索引0）缺失。

所以尝试使用：

I think I know what your problem is.
The parameterarray is zerobased but your first parameter (index 0) is missing.
So try using:

Par2 = aArr(0)  'Path
Par3 = aArr(1)  'File Name
Par4 = aArr(2)  'User Id

这篇关于紧急请任何人在程序调用中帮助解决异常错误的数量或类型的参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！