BULK COLLECT using TYPE Record

DECLARE
   sql_stmt_   VARCHAR2(32000);
  
   CURSOR get_data IS
      SELECT t.order_no,
             t.line_no,
             t.rel_no,
             t.line_item_no,
             t.customer_no,
             t.catalog_no
      FROM   customer_order_line_tab t
      WHERE  ROWNUM <= 10;
  
   -- create type using a cursor
   TYPE temp_rec_type IS TABLE OF get_data%ROWTYPE INDEX BY BINARY_INTEGER;
   temp_rec_   temp_rec_type;
BEGIN
   -- Way 1 - Load data using normal cursor open fecth
   --OPEN  get_data;
   --FETCH get_data BULK COLLECT INTO temp_rec_;
   --CLOSE get_data;
  
   -- Way 2 - Load data using executing sql statement via EXECUTE IMMEDIATE
   sql_stmt_ := 'SELECT t.order_no,
                        t.line_no,
                        t.rel_no,
                        t.line_item_no,
                        t.customer_no,
                        t.catalog_no
                 FROM   customer_order_line_tab t
                 WHERE  ROWNUM <= 10';
  
   EXECUTE IMMEDIATE sql_stmt_ BULK COLLECT INTO temp_rec_;
  
   -- loop of fetch data
   FOR i_ IN 1..temp_rec_.COUNT LOOP
      Dbms_Output.Put_Line(temp_rec_(i_).order_no     || ';' ||
                           temp_rec_(i_).line_no      || ';' ||
                           temp_rec_(i_).rel_no       || ';' ||
                           temp_rec_(i_).line_item_no || ';' ||
                           temp_rec_(i_).customer_no  || ';' ||
                           temp_rec_(i_).catalog_no);
   END LOOP;
END;