title: call an oracle stored procedure that has an IN OUT SYS_REFCURSOR parameter at the same with java
body: <p>I am trying to call a stored procedure in oracle that has a SYS_REFCURSOR as IN OUT at the same time. But I am getting the following error:</p>
  <p><strong>Stored procedure</strong></p>
  <pre><code>PROCEDURE TRADSS_DEVOLUCION(pi_id_transaccion in number,
                              pio_cur_traducido  IN OUT SYS_REFCURSOR) IS
  
     ve_err_msg                     VARCHAR2(2000);
  BEGIN
  .
  .
  .
  </code></pre>
  <p><strong>Repository</strong></p>
  <pre><code>        try (CallableStatement callableStatement = 
              connection.prepareCall(&quot;call OPERATOR.PKG_TRANSLATE.TRADSS_EVOLUTION(?,?)&quot;)){
  
              callableStatement.setString(1, idTrx);
              callableStatement.registerOutParameter(2, OracleTypes.CURSOR);
  
              List&lt;Data&gt; listData = new ArrayList&lt;&gt;();
              ResultSet rst = (ResultSet) callableStatement.getObject(2); // here throw the exception
  
              while (rst.next()) {
                  .
                  .
                  .
  
              }
              response.setLista(listData);
          }catch (Exception ex){
              ex.printStackTrace();
              log.error(&quot;Error in service: {}&quot;, ex.getMessage());
          }
          return response;
  </code></pre>
  <p><strong>Exception</strong></p>
  <pre><code>java.sql.SQLException: Invalid column index
      at oracle.jdbc.driver.OracleCallableStatement.getObject(OracleCallableStatement.java:1745)
      at oracle.jdbc.driver.OracleCallableStatementWrapper.getObject(OracleCallableStatementWrapper.java:639)
      at org.davidmoten.rx.jdbc.pool.internal.ConnectionNonBlockingMemberCallableStatement.getObject(ConnectionNonBlockingMemberCallableStatement.java:299)
      at pe.com.claro.maverick.service.support.sga.repository.impl.SgaRepositoryImpl.findTranslate(SgaRepositoryImpl.java:72)
  </code></pre>