Re: stored procedures returning a resultset/cursor

2004-04-14 Thread Daniel Kasak
Beer Joseph wrote: Hi, is it (mysql v5.0) or might it once be possible, to 'return' a cursor as an out parameter from a stored procedure? In MS SQL Server a stored procedure can return a 'recordset' by simply defining a select statement. In ORACLE one can define a ref cursor output parameter

stored procedures returning a resultset/cursor

2004-04-14 Thread Beer Joseph
Hi, is it (mysql v5.0) or might it once be possible, to 'return' a cursor as an out parameter from a stored procedure? In MS SQL Server a stored procedure can return a 'recordset' by simply defining a select statement. In ORACLE one can define a ref cursor output parameter and 'fill' it within t