A Simple stored procedure is created with Dynamic Result sets 3 However only 2 cursors with return to client are defined within the source code. What will happen when you call the SP ?
Will executes successfully
Fails as limit is 3 but only 2 opened
Executes with warning
Would not allow compiling the SP at the first place