Cost Estimator

I have JChem 5 running in Oracle 10g on a RH EL5 system. One issue that I have run into is getting the cost estimator to run properly. I have a large JChem table that uses a BLOB for the structure. The cost estimator package seems to only work with CLOB objects. I get an error similar to what I see for search attempts if I don't use the utl_raw function to convert from the smiles string to a BLOB:





2008-06-02 08:00:19.788 [UNKNOWN]: DEBUG - chemaxon.jchem.cartridge.costestim.calibra.IdxCalibrator: getActualTime: sql=select count(*) from cpds_jc where jc_compare(cd_structure, ?, ?) = 1


java.sql.SQLException: ORA-29900: operator binding does not exist


ORA-06553: PLS-306: wrong number or types of arguments in call to 'JC_COMPARE'





Is there a version that works correctly on tables with BLOB storage?

Cost estimation support is limited in current JChem Cartridge versions to regular structure tables and to structure columns of VARCHAR2 and CLOB type. I will try to get BLOB support and JChem structure table support into the next JChem version.





Sorry for the inconvenience,


Peter

JChem 5.0.6 has been released including a fix.