A public synonym for JCF package would be nice.

Adding the following to the Jcart installation would be useful to developers who want to use Jcart in PL/SQL but do not want to put their PL/SQL in the Jchem schema, or they want to use select statements containing jc_compare in pl/sql.

create or replace public synonym jcf for jcf;

grant execute on JCHEM.jcf to public;

create or replace public synonym jc_compare for jchem.jc_compare;

grant execute on JCHEM.jc_compare to public;

When I call jc_compare from SQL within PL/SQL in a schema other than JCART, I am now gettiing the error:

ORA-29902: error in executing ODCIIndexStart() routine

ORA-29540: class chemaxon/jchem/cartridge/JCFunctionsClob does not exist

ORA-06512: at "JCHEM.JCHEM_CLOB_PKG", line 81

ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 372

.... however the error does not occur for if the SQL is contained in PL/SQL run in an anonomous block.

~Mike

Mike,

Please see Peter's answer here to essentially the same problem:

https://www.chemaxon.com/forum/viewpost45527.html#45527

More information:

http://www.chemaxon.com/jchem/doc/admin/cartridge.html#users

Please let us know if this helps.

Best regards,

Szilard