Urgent Please can anybody help to resolve exception wrong number or types of arguments in call of Procedure

Question

0.00/5 (No votes)

See more:

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

C#

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

C#

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.

VB

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.

SQL

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

Posted 6-Oct-13 21:20pm

Member 9410081

Updated 7-Oct-13 1:22am

v7

Add a Solution

Comments

Richard MacCutchan 7-Oct-13 4:10am

What are the parameters required by the stored procedure?

Member 9410081 7-Oct-13 6:35am

I have posted the store procedure.

Azee 7-Oct-13 4:16am

Can you post your Store Procedure as well?

Member 9410081 7-Oct-13 6:35am

I have posted the store procedure.

Member 9410081 7-Oct-13 4:23am

I have posted the store procedure.

Richard MacCutchan 7-Oct-13 6:42am

You have not shown the declaration of your stored procedure, so we still cannot guess how many parameters it is looking for.

Member 9410081 7-Oct-13 6:45am

Actua;;y its vb script n m not able to run on my pc so just have this code wid me in wich there is store procedure and parameters.
Par2 = aArr(1) 'Path
Par3 = aArr(2) 'File Name
Par4 = aArr(3) 'User Id

Richard MacCutchan 7-Oct-13 6:53am

I don't think you are talking about a stored procedure here.

Member 9410081 7-Oct-13 7:25am

I have added the store procedure.

Member 9410081 7-Oct-13 7:25am

In question itself i have added store procedure.

ShridharPanigrahi 7-Oct-13 9:32am

Can you try naming the parameters same as your stored procedure parameter names?

Member 9410081 8-Oct-13 0:19am

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

and i am passing parameters as Par2 ,Par3 ,Par4

Jörgen Andersson 7-Oct-13 15:49pm

What version of VB is it?
Can you post o_Cls_OracleConnect.CallStoredProcedure_PreInit() and o_Cls_OracleConnect.CallStoredProcedure_Varchar2_AddParameters?

Member 9410081 8-Oct-13 0:20am

public void CallStoredProcedure_Varchar2_AddParameters(string colname, string colvaluestr)
{
OracleParameter param1 = new OracleParameter(colname, OracleType.VarChar, 100);
param1.Value = colvaluestr;
MyCmd.Parameters.Add(param1);
}

public void CallStoredProcedure_PreInit()
{
MyCmd = new OracleCommand();
MyCmd.CommandType = CommandType.StoredProcedure;
MyCmd.Connection = MydbCon;
}

1 solution

Add a Solution

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

Jörgen Andersson · Accepted Answer · 2013-10-07T23:34:00

Solution 1

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

VB

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

Posted 7-Oct-13 23:34pm

Jörgen Andersson

Comments

Member 9410081 8-Oct-13 6:31am

Thanks.

Urgent Please can anybody help to resolve exception wrong number or types of arguments in call of Procedure

1 solution

Solution 1

Add your solution here

Preview 0

Urgent Please can anybody help to resolve exception wrong number or types of arguments in call of Procedure

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us