The stored procedures you execute must return no result sets or one result set. Stored procedures that return multiple result sets will execute, but all result sets except the first are thrown away.
The connection used when getting result sets from a stored procedure is not available for any other processing while the cursor is open. In other words, if you need to execute other SQL statements based on information from a stored procedure, you must open multiple connections to the database.