How do we return a cursor from MySQL Stored Procedure (Routines). Or another approach to return a list of values back to a Java program from the MySQL Proc. We are trying to implement the similar functionality as Sys Ref Cursor in Oracle and looks like there is similar thing in MySQL. But wondering as this a very common usecase, what should be a the way to get a list of values returned by a proc in mysql.
Version - MySQL-server-5.5.15