What is the type of IS TABLE OF NUMBER(5) INDEX BY BINARY_INTEGER in Java? OracleTypes.ARRAY gives an ORA-03115 exception.
Update: The whole class:
@Repository
public class MerchantEmvRepository {
private SimpleJdbcCall updateMerchantEmvTerminalData;
DataSource dataSource;
@Autowired
public MerchantEmvRepository (DataSource dataSource) {
this.dataSource = dataSource;
}
@Autowired
public void setDataSource (){
JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
jdbcTemplate.setResultsMapCaseInsensitive(true);
this.updateMerchantEmvTerminalData
= new SimpleJdbcCall(jdbcTemplate)
.declareParameters(new SqlOutParameter("RetCodeType", OracleTypes.ARRAY))
.withCatalogName("data")
.withoutProcedureColumnMetaDataAccess()
.withFunctionName("update_merch_emv");
}
public Array updateMerchantEmvTerminalData (String merchantId) {
SqlParameterSource incomingParameters = new MapSqlParameterSource().addValue("i_merch_id", merchantId);
return updateMerchantEmvTerminalData.executeFunction(Array.class, incomingParameters);
}
}