Re[2]: SOLVED: How to define a Type with multiple columns ,for bulk fetch

From: Edgar Chupit <chupit_at_tsi.lv>
Date: Thu, 11 Mar 2004 22:14:21 +0200
Message-ID: <335723265.20040311221421@tsi.lv>

Hello Juan,

JCRP> Yes, but create an object for every specific select, that gathers specific JCRP> columns, you will have lot and lot of objects.

And alternatively you can do it like this:

SQL> get 1.sql
  1 declare
  2 cursor c is select object_name from all_objects;   3 type row_type is table of c%rowtype index by binary_integer;   4 r row_type;
  5 begin
  6 open c;
  7 fetch c bulk collect into r limit 100;   8 close c;
  9 dbms_output.put_line( r.count );
10* end;
11 /
100

PL/SQL procedure successfully completed.

--

Edgar

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Thu Mar 11 2004 - 15:36:08 CST