How does Spark handle stored procedures which return multiple result sets?

The SPARK platform favors dynamic SQL over stored procedures. There is no support for stored procedures (this is by design!). So, if all your data access is through stored procedures then SPARK would be not be the right tool. 

However, if  your foundation is built on SPARK and your situation requires a quick one-off solution for stored procedure access, then you could easily bypass SPARK and write an ADO based method to quickly retrieve your stored procedure with multiple result sets.

Hope this helps.