List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:November 24 2005 12:31pm
Subject:Using a Stored Procedure that returns a resultset
View as plain text  
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

Thread
Using a Stored Procedure that returns a resultsetMartijn Tonies24 Nov
  • Re: Using a Stored Procedure that returns a resultsetPeter Brawley24 Nov
  • Re: Using a Stored Procedure that returns a resultsetMartijn Tonies24 Nov
    • Re: Using a Stored Procedure that returns a resultsetPeter Brawley24 Nov
  • Re: Using a Stored Procedure that returns a resultsetMartijn Tonies25 Nov