set serveroutput on
DECLARE
    TYPE capacity_table IS TABLE OF location.capacity%TYPE
    INDEX BY BINARY_INTEGER;
  current_cap_table Capacity_TABLE;
   CURSOR cap_cursor IS
    SELECT room, capacity
    FROM location;
  cap_cursor_row cap_cursor%ROWTYPE;
  current_cap_key number(3);
  
BEGIN
  --populate the table using the cursor
  FOR cap_cursor_row IN cap_cursor LOOP
     current_cap_table(cap_cursor_row.room) := cap_cursor_row.capacity;
  END LOOP;
  DBMS_OUTPUT.PUT_LINE('The total room count in the CURRENT_cap_TABLE is ' || 
  current_cap_table.COUNT );
  

End loop;

END;
/