Home  /  Questions  /  Question



75   96.3
Jul 09, 2014


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

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



508   99.9
Jul 10, 2014
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.