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".

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.