Cartridge user defined function

Hello,

I followed step by step the user defined molconverter function example of the cartridge, but calling it from sql as

select molconverter(cd_smiles, 'smiles:a') from jchemtable; 

returns the exception:
ORA-29532: a Java hívás nem kezelt Java kivétellel ért véget: java.rmi.NoSuchObjectException: no such object in table
ORA-06512: a(z) "JCHEM.JCHEM_CORE_PKG", helyen a(z) 334. sornál
ORA-06512: a(z) "JCHEM.GETATOMCOUNT_FUNC", helyen a(z) 2. sornál
29532. 00000 -  "Java call terminated by uncaught Java exception: %s"
*Cause:    A Java exception or error was signaled and could not be
           resolved by the Java code.
*Action:   Modify Java code, if this behavior is not intended.

Could you help me please?

Istvan

Hello István,

Try execute the same in a fresh database session. The JChem Cartridge server was probably restarted and your current database session most probably tries using a stale reference to it.

Peter

Peter,

Now it works. Thank you.

Istvan