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


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to