From oracle-l-bounce@freelists.org Thu Mar 11 15:36:08 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2BLa8h21265 for ; Thu, 11 Mar 2004 15:36:08 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2BLa3o21254 for ; Thu, 11 Mar 2004 15:36:03 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5E06F39CC61; Thu, 11 Mar 2004 15:21:46 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 11 Mar 2004 15:20:02 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mail.latnet.lv (mail3.latnet.lv [159.148.108.14]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 07ABE397CEF for ; Thu, 11 Mar 2004 15:09:21 -0500 (EST) Received: (qmail 20866 invoked by uid 102); 11 Mar 2004 20:14:19 -0000 Received: from chupit@tsi.lv by mail3 by uid 64011 with qmail-scanner-1.20 (clamuko: 0.54. Clear:RC:1(159.148.112.229):. Processed in 0.012393 secs); 11 Mar 2004 20:14:19 -0000 Received: from unknown (HELO localhost) (159.148.112.229) by mail3.latnet.lv with SMTP; 11 Mar 2004 20:14:19 -0000 X-AntiVirus: Checked by Dr.Web [version: 4.31a, engine: 4.31b, virus records: 47228, updated: 10.03.2004] Date: Thu, 11 Mar 2004 22:14:21 +0200 From: Edgar Chupit X-Mailer: The Bat! (v1.62i) Educational X-Priority: 3 (Normal) Message-ID: <335723265.20040311221421@tsi.lv> To: Juan Cachito Reyes Pacheco Subject: Re[2]: SOLVED: How to define a Type with multiple columns ,for bulk fetch In-Reply-To: <00ce01c406f0$b0c1b8e0$2501a8c0@dazasoftware.com> References: <00ce01c406f0$b0c1b8e0$2501a8c0@dazasoftware.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-archive-position: 536 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: chupit@tsi.lv Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l 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@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 -----------------------------------------------------------------