multiple result sets

[situ]

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

[Kiran]

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

[situ]

thanks.