I have a Oracle TYPE declared in database, with few attributes.
I have a Java class with the same set of attributes and also implements SQLDATA interface and provided implementation for two of interface methods readSQL() and writeSQL(). These methods are not there in Oracle TYPE. Now, Can I map this java object to Oracle TYPE as follows:
Map typeMap = connection.getTypeMap();
typeMap.put("REQSUM_OBJ_T", Class.forName("RequisitionSummary"));
connection.setTypeMap(typeMap);
callableStatement = connection.prepareCall("{? = call NW2IDAA.INS_REQSUM_PROC(?)}");
callableStatement.setObject(1, reqsum);
callableStatement.execute();
I am getting an error while setting object to callable statement as follows:
java.sql.SQLException: Non supported character set: oracle-character-set-178
Would you like to comment?
Join Diigo for a free account, or sign in if you are already a member.