In my code am getting following error.
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SAVE_DATA'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
What will be the reason for this?
code am using is,
List<oracleparameter> listparamters = new List<oracleparameter>();
OracleParameter prm = null;
OracleParameter prm1 = null;
OracleParameter prm2 = null;
OracleParameter prm3 = null;
OracleParameter prm4 = null;
prm = new OracleParameter(Param, OracleType.VarChar);
prm1 = new OracleParameter(Param1, OracleType.VarChar);
prm2 = new OracleParameter(Param2, OracleType.VarChar);
prm3 = new OracleParameter(Param3, OracleType.VarChar);
prm4 = new OracleParameter(Param4, OracleType.VarChar);
prm.Value = "Test";
prm1.Value = "TRUE";
prm2.Value = "FALSE";
prm3.Value = "FALSE";
prm4.Value = "FALSE";
prm.Direction = ParameterDirection.Input;
prm 1.Direction = ParameterDirection.Input;
prm2.Direction = ParameterDirection.Input;
prm3.Direction = ParameterDirection.Input;
prm3.Direction = ParameterDirection.Input;
paramters.Add(prm);
paramters.Add(prm1);
paramters.Add(prm2);
paramters.Add(prm3);
paramters.Add(prm3);
OracleCommand command = objDataAccessUtilities.GetOracleCommand(SaveData, paramters);
objDataAccessUtilities.ExecuteDataReader(command);
Procedure:
PROCEDURE SAVE_DATA(
Value1 IN varchar2,
Value2 IN varchar2,
Value3 IN varchar2,
Value4 IN varchar2,
Value5 IN varchar2) IS
COUNT INTEGER;
BEGIN
Select count(Field_name) into COUNT from table1 where UPPER(Filed_name)=UPPER(Value1);
IF COUNT>0 THEN
update table1
SET
Field 2=Value2 ,
Field 3=Value2Value3 ,
Field 4=Value2Value4 ,
Field 5=Value2Value5 ,
where UPPER(Filed_name)=UPPER(Value1);
ELSE
INSERT INTO table1(
field,
field,
field,
field,
field,
field,
field,
field,
)
VALUES(
Value,
Value,,
Value,,
Value,,
Value,,
Value,,
SYSDATE,
USER
);
END IF;
commit;
EXCEPTION
WHEN OTHERS THEN
Rollback;
END SAVE_DATA;