Calc Exact mass from Oracle Cartridge?

Is there a way to generate exact mass from Oracle Cartridge api, similar to jc_molweight(structure)?

Thanks,

--Ling

HI Ling,

You can run the following commands:

select jc_evaluate(structure, 'mass()') from ...
select jc_evaluate(structure, 'exactMass()') from ...

Furthermore, here you find the list of the available chemical terms and the operators provided in JChem Oracle Cartridge API.

Regards,

Krisztina

Hi Krisztina,

It worked as expected.

Thanks,

--Ling

Hi Krisztina,

"select jc_evaluate(structure, 'exactMass()') from ..." worked perfectly.

However, I got the error message below when running "select jc_evaluate(structure, 'mass()') from ...".

Do you know  why?

Thanks,

--Ling

 

==========================================================================

ORA-29532: Java call terminated by uncaught Java exception: chemaxon.jchem.cartridge.oraresident.nonidxscan.NonIdxScanException: RemoteException occurred in server thread; nested exception is: 

chemaxon.jchem.cartridge.sharedorajcsrv.rmi.EvaluationException: Error while compiling expression:

Mass()

    Encountered ")" at line 1, column 6.

Was expecting one of:

    ";" ...

    "+" ...

    "-" ...

    <NOT> ...

    <STRING_LITERAL> ...

    <INTEGER_LITERAL> ...

    <FLOATING_POINT_LITERAL> ...

    <IDENTIFIER> ...

    "(" ...

 

ORA-06512: at "JCHEMUSER.JCHEM_CLOB_PKG", line 34

ORA-06512: at "JCHEMUSER.EXEC_FUNCC", line 30

ORA-06512: at "JCHEMUSER.EVALUATE_FUNCC", line 7

Hi Ling,

Please, try running mass() instead of Mass().

Best regards,

Krisztina