Link to home
Start Free TrialLog in
Avatar of sjarmy
sjarmy

asked on

PLS-00703: multiple instances of named argument in list

I am getting this error when caling an Oracle stored procedure. The call is inside a foreach (DataRow dataRow in tempTable.Rows) loop and the first record updates fine, but on the second call, I get the error so I'm guessing I'm not releasing something. Can someone suggect something for this?

Remember its blowing on the second record.
foreach (DataRow dataRow in tempTable.Rows)
 {
      DO STUFF ......
 
    cmd.CommandText = "USER_TABLE_UPDATE";
    cmd.CommandType = CommandType.StoredProcedure;
     OracleParameter parameter0 = new OracleParameter();
     parameter0.ParameterName = "RESULT";
     parameter0.OracleType = OracleType.VarChar;
     parameter0.Direction = ParameterDirection.Output;
 
    parameter0.Size = 30;
    cmd.Parameters.Add(parameter0);
    cmd.Parameters.Add(new OracleParameter("pACTION", OracleType.VarChar)).Value = "update";
   cmd.Parameters.Add(new OracleParameter("pUSERID", OracleType.VarChar)).Value = userid;
   cmd.Parameters.Add(new OracleParameter("pFIRST_NAME", OracleType.VarChar)).Value = fname;
    cmd.Parameters.Add(new OracleParameter("pLAST_NAME", OracleType.VarChar)).Value = lname;
    cmd.Parameters.Add(new OracleParameter("pEMAIL", OracleType.VarChar)).Value = email;
    cmd.Parameters.Add(new OracleParameter("pPHONE", OracleType.VarChar)).Value = phone;
    cmd.Parameters.Add(new OracleParameter("pJOB_LEVEL_ID", OracleType.VarChar)).Value = job_lev;
    cmd.Parameters.Add(new OracleParameter("pMANAGER_DN", OracleType.VarChar)).Value = mgr_dn;
   int int_ins = cmd.ExecuteNonQuery();
 
TOP OF STORED PROCEDURE
 
CREATE OR REPLACE PROCEDURE OISWEB.USER_TABLE_UPDATE(RESULT	 OUT VARCHAR2,
 pACTION   VARCHAR2,
pUSERID 	   USERS.USER_ID %TYPE,
pFIRST_NAME  VARCHAR2,
pLAST_NAME   VARCHAR2,
pEMAIL	   VARCHAR2,
 pPHONE	   VARCHAR2,
 pJOB_LEVEL_ID	 USERS_EXT.JOB_LEVEL_ID%TYPE,
 pMANAGER_DN	 USERS_EXT.MANAGER_DN%TYPE
)

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of daveamour
daveamour
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sjarmy
sjarmy

ASKER

I ended up recoding it all togeter and had it working by the time a received the solution.