CREATE OR REPLACE PROCEDURE sp_delrowinauditorium(a IN CHAR) IS
BEGIN
  DELETE FROM SHEDULESSON WHERE auditorium = a;
  DELETE FROM AUDITORIUM WHERE auditorium = a;
  COMMIT;
END sp_delrowinauditorium;

    protected void DeleteRow(int rowindex)
    {
        OracleConnection conn = new OracleConnection("Data Source=SHLCORE;User Id=system;Password=pass;");
        OracleCommand cmd = new OracleCommand();
        cmd.Connection = conn;
        switch (DropDownList1.SelectedItem.Text)
        {
            case "AUDITORIUM": cmd.CommandText = "sp_delrowinauditorium";
                string auditorium = GridView1.Rows[rowindex].Cells[2].Text;
                cmd.Parameters.Add("auditorium", OracleType.Char, 10).Value = auditorium.ToCharArray();
                cmd.Parameters.Add("count", OracleType.Number).Direction = System.Data.ParameterDirection.Output;
                break;
        }
        cmd.CommandType = System.Data.CommandType.StoredProcedure;
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();
    }