Ref cursor question

From: Mtek <>
Date: Fri, 12 Sep 2008 12:28:01 -0700 (PDT)
Message-ID: <>


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. Received on Fri Sep 12 2008 - 14:28:01 CDT

Original text of this message