MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: Using the result of one stored procedure within another
Posted by: Roland Bouman
Date: August 12, 2005 05:03PM

Yes, It is possible to do just that - make a procedure store results in a (temporary) table and query the (temporary) table in another procedure.
However, you can *NOT* pass a resultset between procedures using a handle or REF CURSOR or ResultSet Type variable. You must copy the data first to a (temporary) table.

Check out this thread:

http://forums.mysql.com/read.php?98,36875


Good luck!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Using the result of one stored procedure within another
2862
Sebastien Lehoux
August 12, 2005 03:44PM
Re: Using the result of one stored procedure within another
2580
Roland Bouman
August 12, 2005 05:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.