Re: Ref cursor question

From: <>
Date: Fri, 12 Sep 2008 21:56:05 +0200
Message-ID: <>

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

>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
Received on Fri Sep 12 2008 - 14:56:05 CDT

Original text of this message