Optional parameter passing from ASP.NET to oracle

See more:

C#

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;
}