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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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: 2476
    
    7

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
 
Similar Threads
Calling a stored procedure with an ARRAY
Class Cast exception in oracle.sql.ArrayDescriptor
cannot create oracle.sql.ArrayDescriptor using connection from weblogice datasource
Passing String array as out parameter to stored procedure
Passing Array as a parameter to Stored procedures