Re: Ref cursor question

On Fri, 12 Sep 2008 12:28:01 -0700 (PDT), Mtek <mtek_at_mtekusa.com> wrote:

>
>Hi,
>
>I'm new to ref cursors. Please look at this:
>
>TYPE select_cursor IS REF CURSOR;
>v_data_crs SELECT_CURSOR;
>v_data_rec DATA_CRS%ROWTYPE;
>
>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 DBA