Bug #12899 Select in Stored Procedure ( return resultset )
Submitted: 31 Aug 2005 7:38 Modified: 29 Sep 2009 12:19
Reporter: Chagh Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0.11 , 5.0.10 OS:Any (All)
Assigned to: CPU Architecture:Any

[31 Aug 2005 7:38] Chagh 
Description:
hi,

Please Please Please, allow select in SPs. it is so critical in many applications. Or please find a solution for this. It is allowed in MySQL connector/Net to get esultsets from SPs and also in MyDAC. we can not upgrade to 5.0.10 or 5.0.11 to use triggers 'cause they do not allow select in SPs.

Oracle doesn't allow select statements in SPs but it has a "sys_refcursor" type which is a cursor and can be used as an out parameter. then it would be returnes when it is opened for a select statement.

It is really critical. please add this feature again.

Thanks Chagh

How to repeat:
upgrade to 5.0.10 or 5.0.11
try to create an SP which has select in it.

Suggested fix:
add the removed property of returning result set in SPs
Oracle has a "sys_refcursor" type which is a cursor and can be used as an out parameter. then it would be returnes when it is opened for a select statement.
[29 Sep 2009 12:19] Valeriy Kravchuk 
Looks like a duplicate of bug #10817.