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

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

thanks.