By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,611 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,611 IT Pros & Developers. It's quick & easy.

multiple result sets

P: n/a
look at the procedure below

CREATE PROCEDURE PR_2 ( )
dynamic result sets 1
BEGIN
declare cursor_1 cursor with return to caller
for select *from elements;
open cursor_1;
END

the above procedure returns only one result set
can any body show me how to return multiple result sets.

thanks in advance

situ

Apr 24 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

CREATE PROCEDURE PR_3 ( )
dynamic result sets 2
BEGIN
declare cursor_1 cursor with return to caller
for select * from elements;

declare cursor_2 cursor with return to caller
for select * from elements;
open cursor_1;
open cursor_2;
END

situ wrote:
look at the procedure below

CREATE PROCEDURE PR_2 ( )
dynamic result sets 1
BEGIN
declare cursor_1 cursor with return to caller
for select *from elements;
open cursor_1;
END

the above procedure returns only one result set
can any body show me how to return multiple result sets.

thanks in advance

situ


Apr 24 '06 #2

P: n/a
thanks.

Apr 24 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.