oracle.sql.ARRAY error "Non supported character set: oracle-character-set-"
746480Jan 14 2010 — edited Jan 15 2010Hello folks,
My java code :
Object[] arrayToPassToDB=new Object[7];
// code to initialize the object array
ArrayDescriptor arraydesc = ArrayDescriptor.createDescriptor(arrayDesc,con);
ARRAY array = null;
array = new ARRAY(arraydesc, con, arrayToPassToDB);
is giving the following error :
Non supported character set: oracle-character-set-178
at oracle.gss.util.NLSError.throwSQLException(NLSError.java:46)
at oracle.sql.CharacterSetUnknown.failCharsetUnknown(CharacterSetFactoryThin.java:171)
at oracle.sql.CharacterSetUnknown.convert(CharacterSetFactoryThin.java:135)
at oracle.sql.CHAR.<init>(CHAR.java:159)
at oracle.sql.CHAR.<init>(CHAR.java:183)
at oracle.jdbc.oracore.OracleTypeCHAR.toDatum(OracleTypeCHAR.java:161)
at oracle.sql.StructDescriptor.toOracleArray(StructDescriptor.java:830)
at oracle.sql.StructDescriptor.toArray(StructDescriptor.java:1735)
at oracle.sql.STRUCT.<init>(STRUCT.java:136)
at oracle.jdbc.oracore.OracleTypeADT.createObjSTRUCT(OracleTypeADT.java:2232)
at oracle.jdbc.oracore.OracleTypeADT.toDatum(OracleTypeADT.java:246)
at oracle.jdbc.oracore.OracleTypeADT.toDatumArray(OracleTypeADT.java:302)
at oracle.jdbc.oracore.OracleTypeUPT.toDatumArray(OracleTypeUPT.java:117)
at oracle.sql.ArrayDescriptor.toOracleArray(ArrayDescriptor.java:1517)
at oracle.sql.ARRAY.<init>(ARRAY.java:117)
can somebody help me ?
I have added the following external jar's in the java build path :
orai18n.jar, ojdbc14.jar, nls_charset12.jar.
I am using jdk1.6.0 and oracle 10g.
Thanks in advance for the help!