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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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.