vRO's database connection does support multiple resultset from a Stored procedure, it is just forgotten in the documentation in vRO. There is a function that is missing in the statemant called getMoreResults, witch will fetch the next resultset.

An example:

var prepstatement = jdbcConnection.prepareStatement("exec SomeStorecProc");
var HasData = prepstatement.execute();
 
 
while (HasData == true)
{
	var resultSet = prepstatement.getResultSet();
	var Row = 0;
        while (resultSet.next())
	{
	        //Get Col Count,
		var ColCount = resultSet.getMetaData().getColumnCount();
		for (var i =1;i<=ColCount;i++)
		{
			// First Row = Colum Header
			if (Row ==0)
			{
				ColumnName = (resultSet.getMetaData().getColumnName(i));
			}
			else
			{
				ColValue = (resultSet.getStringAt(i));
			}
			Row++;
		}
		HasData = prepstatement.getMoreResults(1); // Not documented
	}	
        if (resultSet) resultSet.close();
        if (HasData) statement.close();
	}
}
 
if (jdbcConnection) jdbcConnection.close();