Re: Getting array of rows from PL/SQL

On Thu, 18 Jun 1998 04:27:51 GMT, "avaneesh.arora" <avaneesh.arora_at_mci2000.com> 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
>
>

You can cause the stored procedure to be executed from the client easily enough, right? What's giving you trouble is getting back rows from the stored procedure.

Answer: don't try. The protocols aren't well enough defined yet to do this! Instead, write the procedure so it extracts what you want, a batch at a time, and writes it to a temporary table. Then just use you normal stuff from the client to select from the temp table as you wish.

Let the software do the work!!

James Febbo
SqlEdi_at_mcs.net Received on Thu Jul 02 1998 - 00:00:00 CDT