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.
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
)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER