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

User 0908c5ccdd

30-04-2008 08:59:42

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?

ChemAxon aa7c50abf8

30-04-2008 12:51:03

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

User 0908c5ccdd

30-04-2008 12:59:47

It's JChem v5.0.2

ChemAxon aa7c50abf8

30-04-2008 13:32:24

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

ChemAxon aa7c50abf8

25-05-2008 17:30:54

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





Thanks


Peter