Re: Ref cursor question
Date: Fri, 12 Sep 2008 21:56:05 +0200
On Fri, 12 Sep 2008 12:28:01 -0700 (PDT), Mtek <mtek_at_mtekusa.com> wrote:
>I'm new to ref cursors. Please look at this:
>TYPE select_cursor IS REF CURSOR;
>What is wrong here? I'm going to open up a number of possible
>cursors based on some parameters. So, I thought you define the
>cursor, then define a type of that ref cursor, then you can define a a
>row of that......
>Probably pretty simple what I ask.......but help is appreciated.
You have strongly typed cursors and weakly typed cursors.
REF CURSORs are weakly typed.
It doesn't make sense to define a record based on a weakly typed cursor.
-- Sybrand Bakker Senior Oracle DBAReceived on Fri Sep 12 2008 - 14:56:05 CDT