Re: Cursor on PL/SQL table

From: Ian Jennings <ij_at_microware.demon.co.uk>
Date: Thu, 30 Apr 1998 07:41:32 +0100
Message-ID: <35481D1B.73FAB99F@microware.demon.co.uk>

Hi,

No, I have a PL/SQL table, from my previous example, and I want to have a cursor on it. I declare a cursor variable, exactly as I would on a normal table, and want to return it as a parameter. I keep getting a 'cannot do this with a PL/SQL table', or somesuch.

Thanks

MANISHA HANDA wrote:

> 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 Thu Apr 30 1998 - 01:41:32 CDT