Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Getting array of rows from PL/SQL

Re: Getting array of rows from PL/SQL

From: Chris Bigenwald <cjb3701_at_rit.edu>
Date: 1998/06/21
Message-ID: <358d2bd7.0@isc-newsserver.isc.rit.edu>#1/1

You can also use "where rowcount < x" to limit query to return x-1 rows. This works in sqlplus anyway.

>> Is there a way to get an array of rows back from from a PL/SQL procedure
 ?
>> Specifically, what I am interested in is getting a limited fixed number
 of
>> rows (in batches) at a time from the database and passing it back to the
>> client for display.
Received on Sun Jun 21 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US