|
|
passing String array from Java to Stored Procedure in Oracle
|
Posted: Sep 13, 2007 8:12 AM
|
|
|
Advertisement
|
We are passing String Arrary from Java to Oracle 9i Stored Procedure. We are getting following error :
java.sql.SQLException: Non supported character set: oracle-character-set-46
Below is the code :
DataSource ds =SQLConnect.getDataSource();
Connection conn = ds.getConnection();
Connection nativeConnection = (Connection)WSJdbcUtil.getNativeConnection((WSJdbcConnection)conn);
CallableStatement cs = null;
nativeConnection.setAutoCommit(true);
String strArray[] = {"Account","Marketing"};
cs=conn.prepareCall("{ call GDR_DATA.TEST_PARAMETERS(?) }");
ArrayDescriptor descriptor = ArrayDescriptor.createDescriptor("GDR_DATA.T_TEST", nativeConnection);
ARRAY array_to_pass = new ARRAY(descriptor, nativeConnection, strArray);
cs.setArray(1,array_to_pass);
cs.execute();
we have included utils.jar, rsadapterspi.jar , classes12.zip and ns_charset12.zip in the build path
Any help will be greatly appreciated
|
|
Previous Topic
