Tested in my environments and it is not possible indeed to get results despite being executed correctly in SQL Warehouses. I tried with multiple options but no luck. However, as a workaround, I would recommend to replace or partially replace part of your stored procedures by Databricks functions so that you can use stored procedures for CUD actions while function for retrieving results. I've tested Databricks functions and they work perfectly.

I'll be keeping an aye just in case someone from Databricks could shed more light on this.