Non supported character set: oracle-character-set-178

[Dilshan Edirisuriya]

I need to pass a string array to a oracle stored procedure. For that I have used the following coding.

oracle.sql.ArrayDescriptor descrip = oracle.sql.ArrayDescriptor.createDescriptor(SPNAME,connection);
oracle.sql.ARRAY array = new oracle.sql.ARRAY(descrip, connection, inputObj);
cstmt.setArray(PARAMNO,array);

But when I pass a string array in to the stored procedure it throws sql exception with the non supported character set message. The stored procedure array type is varchar2. I tried adding "orai18n.jar" in to the class path but still the result was the same. So what may be the reason for getting this error. I am using jboss as my application server. Please help me.

Thank you

[Jan Cumps]

it throws sql exception with the non supported character set message

Please post the exception message.

[Dilshan Edirisuriya]

Hi Jan this is the exception I got.

java.sql.SQLException: 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.xdb.XMLType.getBytesString(XMLType.java:1215)
at oracle.xdb.XMLType.getBytesValue(XMLType.java:1151)
at oracle.xdb.XMLType.toDatum(XMLType.java:323)
at oracle.xdb.XMLType.toBytes(XMLType.java:1274)
at
oracle.jdbc.driver.OraclePreparedStatement.setOPAQUE(OraclePreparedStatement.java:1757)
at