Hi, This is 1st time i am working with Oracle using Asp.net. I am currently passing 6 values into my stored procedure for it to run.
However my stored procedure contain 6 parameters.
Just wondering do I need to pass all 6 values in order for it to work ? As i am trying to do the same with 3 but it is showing error saying wrong parameter list.
I am don't want to hit the procedure with the DBNull,
I only want to hit with the minimum value. My procedure is also sets default Null value for the no so important fields.
please help
What I have tried:
public string Update_MS_Group(Int64 GROUP_ID, string GROUP_NAME, string EMAIL_ID, Int64 ACTIVE, string CREATE_BY)
{
var param_array = new TupleList<string, string, OracleDbType>
{
{ "2", "p_flag", OracleDbType.Int64 },
{Convert.ToString(GROUP_ID),"p_group_id", OracleDbType.Int64},
{Convert.ToString(GROUP_NAME), "p_group_name", OracleDbType.NVarchar2 },
{ Convert.ToString(EMAIL_ID), "p_email_id",OracleDbType.NVarchar2 },
{ Convert.ToString(ACTIVE), "p_active",OracleDbType.Int64 },
{ Convert.ToString(CREATE_BY), "p_create_by",OracleDbType.NVarchar2 }
};
string returnval = DL.ExecuteSP("pkg_user_mgmt.prc_group_dml", param_array);
return returnval;
}