1  declare
 2     CURSOR c1(v_num number) IS SELECT a.order_number v1, a.flow_status_code v2,b.line_id v3,
 3                                b.ordered_item v4, b.source_type_code v5, b.flow_status_code v6
 4                                FROM
 5                                oe_order_headers_all a,
 6                                oe_order_lines_all b
 7           WHERE a.header_id=b.header_id
 8           AND a.order_number=v_num;
 9  BEGIN
10   dbms_output.put_line('ordernumber'||' '||'flowstatus'||'  '||'lineid'||'  '||'itemname'||' '||'linetype'||'||'linestatus');
11  dbms_output.put_line('-----------'||' '||'----------'||'  '||'------'||'  '||'--------'||'  '||'--------'||'  '||'----------');
12     FOR v_var IN c1(59219) LOOP
13      EXIT WHEN c1%notfound;
14     dbms_output.put_line( v_var.v1||'       '||v_var.v2||'      '||v_var.v3||'  '||v_var.v4||'   '||v_var.v
15     dbms_output.put_line('Count is:-'||c1%rowcount);
16     end loop;
17     CLOSE c1;  -->Here
18*    end;

ordernumber flowstatus  lineid  itemname  linetype  linestatus
----------- ----------  ------  --------  --------  ----------
59219       CLOSED      236756  XP9007   INTERNAL      CLOSED
Count is:-1

declare
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at line 17

declare
  cursor c1 is (select ... from ...)
  c1r c1%rowtype;
begin
  open c1;
  loop
    fetch c1 into c1r;
    exit when c1%notfound;
    
    <do something here>
  end loop;
  close c1;
end;

for c1r in (select ... from ...) loop
  <do something here>
end loop;