-- Lista de todas as reservas

CREATE or replace PROCEDURE pr_listaReservas
(p_listaRes OUT SYS_REFCURSOR)
IS
BEGIN
  OPEN p_listaRes FOR
    SELECT s.id_sala, s.designacao, r.ID_RESERVA, r.horaI, r.horaF, r.diaReserva, r.dataReserva, r.descricao, r.estado
    FROM Salas S inner join Reservas R on S.id_sala = R.id_sala;
END;

-- Lista de todas as reservas por Sala

CREATE or replace PROCEDURE pr_listaReservasSala
(p_idSala salas.id_sala%type,
p_listaResSala OUT SYS_REFCURSOR)
IS
BEGIN
  OPEN p_listaResSala FOR
    SELECT s.id_sala, s.designacao, r.ID_RESERVA, r.horaI, r.horaF, r.diaReserva, r.dataReserva, r.descricao, r.estado
    FROM Salas S inner join Reservas R on S.id_sala = R.id_sala
    where R.id_sala = p_idsala;
END;