Re: Cursor on PL/SQL table

From: Ian Jennings <ij_at_microware.demon.co.uk>
Date: Fri, 01 May 1998 07:26:41 +0100
Message-ID: <35496B20.BE8EAA0C@microware.demon.co.uk>

Hi Leo,

Thanks, tried that. I can get the values, it's a matter of trying to get them into a 'cursor' to pass back as a parameter, row at a time. I didn't want to have to set each 'crs.field1 := tbl.field1' all the way through and was trying to get a whole 'lumpful'.

Thanks again

leo.larson wrote:

> 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
> >
> >

--

---

Ian Jennings
Microware Data Services

This post is made entirely from recycled ones and noughts

---

Received on Fri May 01 1998 - 01:26:41 CDT