Re: PL/SQL and Arrays

Ed Hillmann wrote:
>
> Check out
>
> Http://feta-www.us.oracle.com/products/oracle7/oracle7.3/html/oracle7.3_fs..html
>
> It looks like in version 7.3 of the Oracle server, the PL/SQL (version
> 2.3 of that) will allow "PL/SQL applications to retrieve multi-row
> result sets from stored procedures."
>
> Now, PL/SQL apps can, whether or not SQL*Net can handle it or the
> interface between the database and your app, if it ain't a PL/SQL app,
> sounds like it could be another story....
>
> Ed
> ias_at_magi.com wrote:
>
> >Is there anyway using ANY version of PL/SQL that will allow me to pass
> >result sets (arrays), back to my users?
 

> >The arrays that are to be returned are of variable size (number of
> >records), does the cause more problems?
 

> >If not arrays, can I pass records back to the users somehow?
 

> >Thats a lot of questions, I would really like an answer, please help.
 

> >Thanks,
 

> >Ian Abramson

You can use PL/SQL tables in Ver 2.3 with %ROWTYPE anchorage.

for example

TYPE emp_tab IS TABLE OF emp%ROWTYPE

   INDEX BY BINARY_INTEGER; hope this helps.....

AMARENDRA B NETTEM
http://www.iit.edu/~nettama Received on Sat Sep 21 1996 - 00:00:00 CEST