Ref cursor question

#1

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.

#2

On Fri, 12 Sep 2008 12:28:01 -0700 (PDT), Mtek <mtek (AT) mtekusa (DOT) com>
wrote:

Quote:

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

#3

On Fri, 12 Sep 2008 12:28:01 -0700 (PDT), Mtek <mtek (AT) mtekusa (DOT) com>
wrote:

Quote:

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

#4

On Fri, 12 Sep 2008 12:28:01 -0700 (PDT), Mtek <mtek (AT) mtekusa (DOT) com>
wrote:

Quote:

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

#5

On Fri, 12 Sep 2008 12:28:01 -0700 (PDT), Mtek <mtek (AT) mtekusa (DOT) com>
wrote:

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Ref cursor question

comp.databases.oracle.misc comp.databases.oracle.misc

Ref cursor question - 09-12-2008 , 02:28 PM

Re: Ref cursor question - 09-12-2008 , 02:56 PM

Re: Ref cursor question - 09-12-2008 , 02:56 PM

Re: Ref cursor question - 09-12-2008 , 02:56 PM

Re: Ref cursor question - 09-12-2008 , 02:56 PM