Re: Getting array of rows from PL/SQL

From: Srinagesh Battula <nagesh.battula_at_ips-sendero.com>
Date: 1998/06/19
Message-ID: <358A915B.7594A5E7@ips-sendero.com>#1/1

I know for sure that in Oracle8 you can use DBMS_SQL package which allows you to use arraybinding in inserts/updates and fetches.

Srinagesh Battula

avaneesh.arora wrote:

> Hi All,
>
> 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.
>
> Any help/pointers will be appreciated.
>
> Thanks,
> Avaneesh
Received on Fri Jun 19 1998 - 00:00:00 CDT