CREATE OR REPLACE PROCEDURE phone_insert(in_id in out integer,
                                        in_fname in varchar2,
                                        in_sname in varchar2,
                                        in_lname in varchar2,
                                        in_city in varchar2,
                                        in_tel_number in varchar2) IS
BEGIN
  SELECT phone_SEQ.NEXTVAL INTO in_id FROM dual;
  insert into phone
    (id,
    fname,
    sname,
    lname,
    city,
    tel_number)
  values
    (in_id,
    in_fname,
    in_sname,
    in_lname,
    in_city,
    in_tel_number);

  COMMIT;
END phone_insert;

create or replace procedure phone_select
    (in_fname       in varchar,
    in_sname        in varchar, 
    in_city         in varchar,
    cur           out sys_refcursor) 

is
begin
  open cur for
  
  select 
       p.id, 
       p.fname, 
       p.sname, 
       p.lname, 
       p.city, 
       p.tel_number 
  from phone p
           
       where 1=1
       and NVL(p.fname,0) like '%' || NVL(in_fname, p.fname) || '%'
       and NVL(p.sname,0) like '%' || NVL(in_sname, p.sname) || '%'
       and NVL(p.city,0) like '%' || NVL(in_city, p.city) || '%';
       
end phone_select;

        protected void Button1_Click(object sender, EventArgs e)
        {
            using (SqlConnection con = new SqlConnection(dc.Con))
            {
                using (SqlCommand cmd = new SqlCommand("phone_insert", con))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.Add("in_fname",      OracleDbType.Varchar2).Value = tbFname.Text;
                    cmd.Parameters.Add("in_sname",      OracleDbType.Varchar2).Value = tbSname.Text;
                    cmd.Parameters.Add("in_lname",      OracleDbType.Varchar2).Value = tbLName.Text;
                    cmd.Parameters.Add("in_city",       OracleDbType.Varchar2).Value = tbCity.Text;
                    cmd.Parameters.Add("in_tel_number", OracleDbType.Varchar2).Value = tbTelNumber.Text;

                    con.Open();
                    cmd.ExecuteNonQuery();
                }
            }
        }

 protected void Button1_Click(object sender, EventArgs e)
        {
            OracleConnection con = new OracleConnection(connectionString);
            OracleCommand cmd = new OracleCommand("PHONE_INSERT", con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("in_fname",      OracleDbType.Varchar2, tbFname.Text, ParameterDirection.Input);
            cmd.Parameters.Add("in_sname",      OracleDbType.Varchar2, tbSname.Text, ParameterDirection.Input);
            cmd.Parameters.Add("in_lname",      OracleDbType.Varchar2, tbLName.Text, ParameterDirection.Input);
            cmd.Parameters.Add("in_city",       OracleDbType.Varchar2, tbCity.Text, ParameterDirection.Input);
            cmd.Parameters.Add("in_tel_number", OracleDbType.Varchar2, tbTelNumber.Text, ParameterDirection.Input);
            //cmd.Parameters.Add("in_id", OracleDbType.Int32, 256, null, ParameterDirection.Output); // это выходной параметр
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }

cmd.Parameters.Add("in_id", OracleDbType.Int32, 256, null, ParameterDirection.Output);