Re: REF CURSOR returning a PL/SQL Table.

On 8 Feb 2002, billiauk_at_yahoo.co.uk wrote:

> I think I have it!!!! I'm not letting this one win...

Now, you are the type of person I like to correspond with! :-)

> In the Native Dynamic SQL version, Oracle knows nothing about
> "l_data" as it is local to the procedure being executed and not
> therefore know outside of that scope. NDS will operate outside
> of the local procedure and be using the SQL engine. So even
> though the l_data array will be filled, the NDS ref cursor
> can't access it.

This sounds very plausible to me.

You asked for the full package. Let me defer this until later. I want to organize it nicely, but I'm at work and don't want to take that time, right now.

I was just checking the group to see if anybody had found this interesting enough to answer this and saw your reply. Wanted to thank you right away.

-- 
Galen Boyer