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: James Febbo <SqlEdi_at_mcs.net>
Date: 1998/07/02
Message-ID: <35988d94.28021460@news.mcs.net>#1/1

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

Original text of this message

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