CREATE OR REPLACE PROCEDURE show_reservations IS
 CURSOR c_reservation IS SELECT
            d.document_id,
            d.title,
            d.isbn,
            a.name,
            a.author_id,
            a.surname,
            r.date_reservation,
            r.date_expiration,
            r.active,
            r.quantity_documents,
            r.reader_id,
            r.reservation_id,
            re.reader_id,
            re.firstname,
            re.surname
     FROM documents d,
          authors a,
          reservations r,
          readers re,
          author_document ad
     WHERE a.author_id = ad.author_id,
            d.document_id = ad.document_id,
           d.document_id = r.document_id,
           r.reader_id = re.reader_id;
r_reservation c_reservation%rowtype;
 BEGIN
 htp.htmlOpen;
 htp.headOpen;
 htp.title('SYSTEM BIBLIOTECZNY - rezerwacje');
 htp.headClose;
 htp.bodyOpen;
 htp.p('LISTA REZERWACJI');
 htp.p('<TABLE BORDER=2>');
 htp.p('<TR><TH>ID rezerwacji</TH><TH>ID czytelnika</TH><TH>Czytelnik</TH><TH>ID dokumentu</TH><TH>Autor</TH><TH>Tytuł</TH><TH>ISBN</TH><TH>Data rezerwacji</TH><TH>Termin ważności</TH> <TH>Aktywność</TH>
    <TH>Ilość sztuk</TH><TH>Szczegóły</TH></TR>');
  FOR r_reservation IN c_reservation LOOP
  htp.p('<TD>'||r_reservation.r.reservation_id ||'</TD>');
            htp.p('<TD>'||r_reservation.re.reader_id ||'</TD>');
            htp.p('<TD>'||r_reservation.re.firstname || ' ' || r_reservation.re.surname ||'</TD>');
           htp.p('<TD>'||r_reservation.d.document_id ||'</TD>');
           htp.p('<TD>'||r_reservation.a.name || ' ' ||r_reservation.a.surname||'</TD>');
           htp.p('<TD>'||r_reservation.d.title ||'</TD>');
           htp.p('<TD>'||r_reservation.d.isbn||'</TD>');
           htp.p('<TD>'||r_reservation.r.date_reservation||'</TD>');
           htp.p('<TD>'||r_reservation.r.date_expiration||'</TD>');
           htp.p('<TD>'||r_reservation.r.active||'</TD>');
           htp.p('<TD>'||r_reservation.r.quantity_documents||'</TD>');
           htp.p('<TD>  <a href="show_document?id='||r_reservation.d.document_id||'">Szczegóły</a> </TD>');
           END LOOP;
           htp.p('</TABLE>');
           htp.bodyClose;
           htp.htmlClose;
           END show_reservations;
           /