From: Martijn Tonies
Date: November 24 2005 12:31pm
Subject: Using a Stored Procedure that returns a resultset
List-Archive: http://lists.mysql.com/mysql/192129
Message-Id: <004e01c5f0f3$01b47510$c802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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