Returning Multiple Rows to the calling program?
From: Chakravarthy Nalamotu <kittu_at_gis.eng.hawaii.edu>
Date: 1996/09/05
Message-ID: <50mkqg$hb6_at_news.Hawaii.Edu>#1/1
Date: 1996/09/05
Message-ID: <50mkqg$hb6_at_news.Hawaii.Edu>#1/1
Hi Oracle Users,
Are there any work arounds to return multiple
rows to the calling programs?
Is it possible to return a PL/SQL table
as an OUT parameter?
Using IN, OUT parameters, I am presently able
to return one record at a time. In order to
retrieve multiple rows, the apps are doing
SELECT on the client machines.
This resulted in a huge SQLAREA with
all these select statements.
Thanks for your replies,
Kittu.
Received on Thu Sep 05 1996 - 00:00:00 CEST