how to run stored procedure from groovy that returns multiple resultsets

Question

I couldnt find any good example of doing this online.

Can someone please show how to run a stored procedure (that returns multiple resultsets) from groovy?

Basically I am just trying to determine how many resultsets the stored procedure returns..

Answer 1

All Java classes are usable from Groovy. If Groovy does not give you a way to do it, then you can do it Java-way using JDBC callable statements.

Answer 2

I just stumbled across what could possibly be a solution to your problem, if an example was what you were after, have a look at the reply to this thread