In our Advanced Handlers class I demonstrate how to retrieve multiple records from the database using the Result Set page settings. You have to create the fields for the Result Set through the Utilities|Stored Procedure menu, and give the correct ordinal position and data type of each, but once the bindings are set up you should be able to populate the bound variables just like you do with a DB Query, using a DB Fetch to loop around and get each record result set in turn. I know what the Help says, but I don't think it is correct.
Maybe something has changed, but I'm pretty sure I showed this in my last class running IC 3.0 SU10 or 11. Try it and see - if you get one result set, then you should be able to loop through and get the rest (but only via bindings on the Result Set tab, not the Parameters tab - that would just be for inputs to the sproc).