Re: Package Cursor Question

From: E Richard Leiman & Eva <emad100_at_earthlink.net>
Date: Fri, 28 Mar 2003 01:56:16 GMT
Message-ID: <4ZNga.22861$jA2.2041574@newsread2.prod.itd.earthlink.net>

Dear Daniel,

Hi.

No, it was not to populate a block with a ref cursor.

It's my guess that the cursor in the package can only be called from a procedure, or function in that package.

Can you tell me if there is an advantage to creating the cursor as shown in the book, or simply creating a cursor in the global area of the package?

> If I understand where you are heading it can not be done. If the intent is
to
> populate a datablock use a REF CURSOR as the OUT parameter from a
procedure.
>
> Daniel Morgan
>
>
Received on Thu Mar 27 2003 - 19:56:16 CST