Martin >CREATE PROCEDURE P_Select() >READS SQL DATA >begin >select * from enum_table; >end >How would I get a resultset?
No need for an OUT param, just call the sproc, you'll see. PB ----- Martijn Tonies wrote:
Hi there, I cannot figure out how to use a Stored Procedure that returns a resultset and I cannot find it in the documentation. For example: CREATE PROCEDURE P_Select() READS SQL DATA begin select * from enum_table; end I believe that CALL can only be used for output parameters, correct? How would I get a resultset? With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com
-- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.6/179 - Release Date: 11/23/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
