ORA-03115:

unsupported network datatype or representation

Cause:

A user bind or define, or an Oracle function, is not supported by this heterogeneous Net8 connection.

Action:

Upgrade the older version of Oracle and try again.

 

 

jdbcTemplate.execute(
     sql, 
    new CallableStatementCallback() {
     public Object doInCallableStatement(CallableStatement cs)
     throws SQLException, DataAccessException {
      ResultSet rs = null;
      try {
        
       rs = cs.executeQuery(sqlSelectPosnFlatAndUnsettled);      ResultSetExtractor extractor 
        = new RowMapperResultSetExtractor(new UnsettledIndAmtDataRowMapper());
       return extractor.extractData(rs);
      }
      finally {
       JdbcUtils.closeResultSet(rs);
      }
     }
    } 
 
change to:
 simpleJdbcTemplate.query(
     sqlSelectPosnFlatAndUnsettled, 
     new UnsettledIndAmtDataRowMapper(),
     ptrsId
     );