aspose file tools*
The moose likes JDBC and the fly likes Non supported character set: oracle-character-set-178 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Non supported character set: oracle-character-set-178" Watch "Non supported character set: oracle-character-set-178" New topic
Author

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

Dilshan Edirisuriya
Ranch Hand

Joined: Apr 22, 2006
Posts: 299
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


Dilshan Edirisuriya SCJP1.4, SCWCD1.4, SCBCD 5
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2510
    
  10

it throws sql exception with the non supported character set message
Please post the exception message.


OCUP UML fundamental and ITIL foundation
youtube channel
Dilshan Edirisuriya
Ranch Hand

Joined: Apr 22, 2006
Posts: 299
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Non supported character set: oracle-character-set-178