title: Call stored procedure using Spring SimpleJdbcCall with callback
body: <p>I have an Oracle Stored procedure that takes CLOB input and REFCURSOR output. I invoke the SP via Spring SimpleJdbcCall passing in a RowMapper to map the results.</p>
  
  <p>However, since the result set is large, I need to provide callback feature to the client. I can't quite figure out how to add callback for an SP call using Spring - both with and without SimpleJdbcCall.</p>
  
  <p>One thought I have is to pass-in a RowCallbackHandler. Will this work or is there a better way to solve this problem? Any help here is appreciated.</p>
  
  <pre><code>    private Map&lt;String, Object&gt; arguments = ...;
      SimpleJdbcCall jdbcCall = new SimpleJdbcCall(this.jdbcTemplate)
              .withCatalogName(this.packageName)
              .withProcedureName(this.storedProcName)
              .withoutProcedureColumnMetaDataAccess()
              .declareParameters(this.outputParameters.toArray(new SqlOutParameter[]{}));
  
      if(!isEmpty(inputParameters)) {
          jdbcCall.declareParameters(inputParameters.toArray(new SqlParameter[]{}));
      }
  
      this.outputParameters.add(new SqlOutParameter(outputParamName, VARCHAR, rowMapper));
  
      jdbcCall.execute(arguments);
  </code></pre>