CREATE OR REPLACE PROCEDURE APPS.plsql_tables
IS
   TYPE header_id_type IS TABLE OF oe_order_headers_all.header_id%TYPE
      INDEX BY PLS_INTEGER;

   header_id_tab   header_id_type;

   CURSOR c1
   IS
      SELECT header_id
        FROM oe_order_headers_all;

   i number:= 0;
BEGIN

   FOR prec IN c1
   LOOP
      i := i + 1;
      header_id_tab (i) := prec.header_id;
      dbms_output.put_line('the value of header value '||header_id_tab(i));
   END LOOP;
   
  
END plsql_tables;


SELECT COUNT(*) FROM OE_ORDER_HEADERS_ALL;

COUNT
-----
987089