JC_INSERT issue with "ORA-00903: invalid table name&quo

I am attempting to insert structures into my JChem structures table. I have a PL/SQL procedure that includes a call to the JC_INSERT function but it is giving me the error message below:

Code:

* ERROR at line 1: ORA-29532: Java call terminated by uncaught Java exception: oracle.jdbc.driver.OracleSQLException: ORA-00903: invalid table name ORA-06512: at "JCHEM.JCHEM_TABLE_PKG", line 30 ORA-06512: at "JCHEM.JCHEM_TABLE_PKG", line 19 ORA-06512: at "JCHEM.SID", line 561 ORA-06512: at "JCHEM.SID", line 766 ORA-06512: at line 1

The line giving the error is:

Code:

aCDReturn := jchem_table_pkg.jc_insert(vSmiles, 'compounds', null, 'false', 'false', ''); iCDNum := aCDReturn(1);

The COMPOUNDS table does exist and the PL/SQL is called from within the same schema. Any ideas where I might be going wrong here?

Which JChem version are you using?





The corresponding Java stack trace from Oracle session trace (in the udump directory) would be also helpful.





Thanks


Peter

It's JChem v5.0.2

This is a bug in JChem Cartridge which will be fixed in the next JChem release. In the meantime, I suggest to explicitely specify the name of the JChemProperties table (third parameter to jc_insert).





Thank you for reporting this problem and sorry for the inconvenience.





Thanks


Peter

JChem 5.0.4 has been released including the fix for this problem.





Thanks


Peter