SET SERVEROUTPUT ON
DECLARE
  v_tab  dbms_sql.varchar2_table;
  CURSOR c IS SELECT table_name FROM user_tables;
BEGIN
  -- Populate the varchar2_table...
  OPEN c;
  FETCH c BULK COLLECT INTO v_tab;
  CLOSE c;

  -- Retrieve records from varchar2_table...
  FOR i IN v_tab.FIRST .. v_tab.LAST LOOP
    dbms_output.put_line('Value for row '||i||' = '||v_tab(i));
  END LOOP;
END;
/