Bug #17669 Stored procedures require prepared invocation API
Submitted: 23 Feb 2006 13:56 Modified: 2 Jun 2015 7:58
Reporter: Domas Mituzas Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S4 (Feature request)
Version:5.0, 5.1 OS:Any
Assigned to: CPU Architecture:Any

[23 Feb 2006 13:56] Domas Mituzas
Description:
As prepared statements do not support multiple resultsets in order to bind variables and properly call a stored procedure one has to:

- Prepare, bind and execute SET @var=x,@var2=y
- Execute CALL sp(@var,@var2)
- Use general resultset retrieval
- Prepare, execute and fetch SELECT @var,@var2

Ability to use single prepared statement invocation for this sequence would improve usage of MySQL storade procedures. 

How to repeat:
n/a

Suggested fix:
Allow using multiple resultsets for prepared statements or provide additional tree of API calls for efficient usage of stored procedures.
[22 Jan 2011 21:12] Alexander Nozdrin
Isn't this implemented by
WL#4435 (Support OUT-parameters in prepared statements)?
[23 Feb 2011 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".