Re: Getting array of rows from PL/SQL

From: <derwin_at_my-dejanews.com>
Date: 1998/06/23
Message-ID: <6moht1$lqd$1@nnrp1.dejanews.com>#1/1

Let me guess you do this in Sybase or SQL Server? You can directly accomplish the same thing with PL/SQL. You can return PL/SQL tables (rows) but not sure how you plan to display them.

In other languages you could
create procedure x as select * from dual; You can't do this in PL/SQL.

In PL/SQL the select has to go "INTO" a variable. period. Daryl

In article <358d2bd7.0_at_isc-newsserver.isc.rit.edu>, "Chris Bigenwald" <cjb3701_at_rit.edu> wrote:
>
> You can also use "where rowcount < x" to limit query to return x-1 rows.
> This works in sqlplus anyway.
>
> - Chris Bigenwald
>
> >> 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.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 23 1998 - 00:00:00 CDT