ORA-03115: unsupported network datatype or representation error

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
    );