Cartridge jc_insert error

Dear all:





   There are some error message  when I use cartridge jc_insert function. the following is its error message(cartridge version 5.1.3_2)





java.rmi.RemoteException: ORA-00942: table or view not exist





ORA-06512: 在 "ACD3D20083.JCHEM_TABLE_PKG", line 30


ORA-06512: 在 "ACD3D20083.JCHEM_TABLE_PKG", line 19


ORA-06512: 在 line 1


>





Who can help me solve this problem? Thanks a lot!

Dear Allen,








What is the statement which failed?





Thanks





Peter

Quote:

Dear Allen, What is the statement which failed? Thanks Peter

.Dear Peter,





 I used jc_insert function as following in java:








String procedure = "{? = call jchem_table_pkg.jc_insert(?, ?, ?, ?, ?, ?)}";


  ResultSet rst = null;


  CallableStatement cstmt = null;


  


  try {


   conn.setAutoCommit(false);


   cstmt = conn.prepareCall(procedure);


   <span style="font-size: 10px;">cstmt.registerOutParameter(1, OracleTypes.ARRAY, "CD_ID_ARRAY");


   cstmt.setString(2,  "structure");


   cstmt.setString(3, "tableName");


   cstmt.setString(4, "jchemproperties");


   cstmt.setString(5, "true");


   cstmt.setString(6, "false");


   cstmt.setString(7, "flags:c haltOnBadFormat:n");


   cstmt.execute();


   conn.commit();


} catch (SQLException e) {


  ......


}


   When the statement excute, the error message throw out like I said before.





Allen


Thanks

Try prefixing the table names with the name of schema where they can be found.





Peter

Dear peter,


  I appreciate your patience assist.I had added the table prefix of schema,but the error still happened.Whether there is problem of the cartridge server installed？





Allen

Dear Peter,


I'm very sorry, I forgot added the schema of Jchempropties table,you are very right,There is no prolem now,Thank you very much!





Allen