Re: Stored procedures

From: Brian Price <bprice2000_at_sprintmail.com>
Date: 1998/03/18
Message-ID: <6eqch7$bnt$1@newsfep3.sprintmail.com>#1/1

SteverR wrote in message
<1998031903542601.WAA14929_at_ladder01.news.aol.com>...
>Is there a way to write a stored procedure that will send all the rows of a
>query to the client that executed the stored procedure so it can store all
rows
>in memory and process row by row without having to use cursors and access
row
>by row over the network?

If the client has pl/sql 2.0 or greater, then the procedure could populate a pl/sql table of records and return it to the client. Then the client would just have to process the pl/sql table. This works great in forms 5.0.

Brian Received on Wed Mar 18 1998 - 00:00:00 CST