469,645 Members | 1,634 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

multiple result sets

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
2 3117

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
thanks.

Apr 24 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Darko Jovisic | last post: by
5 posts views Thread by Oksana Yasynska | last post: by
5 posts views Thread by Stanley Sinclair | last post: by
1 post views Thread by randall g | last post: by
3 posts views Thread by =?Utf-8?B?bWljaGFlbCBzb3JlbnM=?= | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.