Ref cursor question

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