How to get multiple result set using executeStoredProcedureForQuery

Hi Community,

Trying to replace store proc. plugin with executeStoredProcedureForQuery, But due to limitation it results only 1000 rows in one result set. 

As per the documentation a!executeStoredProcedureForQuery() Function - Appian 25.3, 

I have modified custome.proerties file with below settings but still not sure how I should get 10 result set with 1000 rows in each?

conf.executeStoredProcedure.limits.maxRowsPerResultSet=1000

conf.executeStoredProcedure.limits.maxTotalRows=10000

Do I need to change store proc to get multiple result set? 

can we increases more that 10K records using conf.executeStoredProcedure.limits.maxTotalRows configuration?

Thanks in advance.

Bhushan