Bharath Bhat
Active User
Joined: 20 Mar 2008
Posts: 283
Location: chennai
|
|
|
|
If you know how to write a stored procedure for 1 result set, you'll be able to write it for multiple result sets as well. You need to have as many
| Code: |
| OPEN cursor CURSOR WITH RETURN |
as the number of result sets. Your routine should specify the resultset parameter >= no. of result set you expect from the Stored proc. |
|
