Result Set Was Not Called. Not all databases and JDBC drivers support all ResultSet types. In addition to returning output parameters a stored procedure can return a result set that is a result table associated with a cursor opened in the stored procedure to the application that issues the CALL statement.
As SQL is a declarative programming language SELECT queries specify a result set but do not specify how to. Keep the cursor open for the client application - do not close them. The application might receive a resource unavailable message if the CALL statement causes the values of the maximum number of active stored procedures or maximum number open cursors to be exceeded.
To return a result set to the outermost procedure in an environment where there are nested stored procedures the RETURN TO CLIENT returnability attribute should be used on the DECLARE CURSOR statement or on the SET RESULT SETS statement to indicate that the cursors are to be returned to the application which called the outermost procedure.
Not all databases and JDBC drivers support all ResultSet types. When I iterated to my result set via getMoreResults being called a few times the column names and everything were there but no row that I could access. The text about queries shows how the result of a query is returned as a javasqlResultSetThis ResultSet is then iterated to inspect the result. To return a result set to the outermost procedure in an environment where there are nested stored procedures the RETURN TO CLIENT returnability attribute should be used on the DECLARE CURSOR statement or on the SET RESULT SETS statement to indicate that the cursors are to be returned to the application which called the outermost procedure.