Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL: cursor variables can point to cursors?
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
![]() |
![]() |