Cursor Variables and passing cursors as parameters.

From: Keith Jamieson <jamiesonk_at_phoenix.ie>
Date: Wed, 1 Sep 1999 16:06:58 +0100
Message-ID: <7qjfgl$as9$1@ezekiel.eunet.ie>

Can anyone tell me if this is possible, and if so please can you give me an example:

What I would like to be able to do is to pass a cursor to a procedure, but also be able to pass a parameter to that same cursor to the procedure. CREATE OR REPLACE
PROCEDURE cursor_par_eg(value_in NUMBER := 0,

                                                     curvar_in IN

curvar_type)

value_in would then be used in the where clause of the cursor. Received on Wed Sep 01 1999 - 10:06:58 CDT