SQL*Plus: Release 11.1.0.6.0 - Production on Fri Sep 3 10:17:14 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
SQL> set serverout on
SQL> declare
v_sql varchar2(32767);
type t_order_no is table of varchar2(10) index by simple_integer;
v_order_no t_order_no;
begin
execute immediate
'select order_no from cs3sys.opheadm@cliff where status in (''C'',''I'',''9'',''8'')'
bulk collect into v_order_no;
dbms_output.put_line(v_order_no.count);
end;
/
589823
PL/SQL procedure successfully completed.
SQL> SELECT COUNT(*) FROM CS3SYS.OPHEADM@CLIFF WHERE STATUS IN ('C','I','9','8');
COUNT(*)
----------
617929
SQL> declare
v_sql varchar2(32767);
type t_order_no is table of varchar2(10) index by simple_integer;
v_order_no t_order_no;
begin
execute immediate
'select order_no from cs3sys.opheadm@cliff where status in (''C'',''I'',''9'',''8'')'
bulk collect into v_order_no;
dbms_output.put_line(v_order_no.count);
end;
/
65535
PL/SQL procedure successfully completed.
SQL>