Re: Fields in variable cursor

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 08 Jul 2004 17:48:47 -0700
Message-ID: <1089334141.107756@yasure>

Oracle Newbie wrote:

>>I am at a complete loss to understnd what it is you are trying to do.

>
> Just learning to pass/return cursor variables.

Than run the demo on the web page I provided you (below).
>

>>You declared a REF CURSOR? Why you did it as you did I have no idea
>>(in the future use SYS_REFCURSOR)

>
> What's the difference between SYS_REFCURSOR and REF CURSOR?

With weakly typed REF CURSORS, as of 9i, you should declare them using the internally defined type SYS_REFCURSOR in the same way you would write x VARCHAR2(20).

Daniel Morgan Received on Thu Jul 08 2004 - 19:48:47 CDT