Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL: cursor variables can point to cursors?

Re: PL/SQL: cursor variables can point to cursors?

From: Alexander Zimmer <zimmer_at_hollomey.com>
Date: Tue, 3 Dec 2002 18:15:02 +0100
Message-ID: <MPG.1857050290fedeab9896d1@news.cis.dfn.de>


rogel_at_web.de tipperte...
> did U look at
> http://tinyurl.com/36kq
> ?

I looked at it now ;)

Alright, this is a possible solution for my problem:

I create a package with a procedure that has a REF CURSOR TYPE as one parameter and x_which_cursor as the second parameter. This procedure returns the cursor variable after opening the right one (depending on x_which_cursor).
And in the calling code, I fetch rows from the returned cursor variable...

Works (as it is described in the section starting with "To centralize data retrieval, you can group type-compatible queries in a stored procedure" in the document you pointed me at).

Anyway, I really would appreciate if I could parametrize these cursor variables! This does not work (as it is decribed with "Unlike cursors, cursor variables take no parameters.").

THX for poking my nose onto this interesting document! Alex Received on Tue Dec 03 2002 - 11:15:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US