A pl/sql table is more like an unbounded array. You can't manipulate it by
select statements, you have to build a for loop with variables to access
each element of the table, or if you know the element number it is indexed
by.
MANISHA HANDA wrote in message <35477CD1.B27D0EFC_at_ssax.com>...
>From what I understand of your question,
>you want to return a list of rows retrieved from
>a table of your choice.
>Have never heard of the concept of returning a CURSOR,
>but couldn't you use an ARRAY instead? Fetch all the
>rows into the ARRAY, and then return this ARRAY to the
>calling program?
>Just an idea!
>
>Manisha
>
>
Received on Thu Apr 30 1998 - 21:27:47 CDT
