how do I return a cursor from a function?
I've got this in MySQL Query Browser, but it won't work:
DELIMITER $$
create function test_fn(param integer)
returns cursor
begin
declare some_cur cursor for select * from foo where bar = param;
return some_cur;
end $$
DELIMITER ;
Please tell me what is wrong.
Thank you,
Pia
Subject
Views
Written By
Posted
how do I return a cursor from a function?
11590
November 29, 2005 02:54PM
6006
November 29, 2005 06:33PM
4853
December 05, 2005 02:36PM
5127
December 05, 2005 03:26PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.