Using a Stored Procedure that returns a resultset

[Martijn Tonies]

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