composition and dotDisconnectedFormula

Hi.


JCHEM_CORE_PKG.GETENVIRONMENT()


--------------------------------------------------------------------------------


Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bi


PL/SQL Release 10.1.0.5.0 - Production


CORE 10.1.0.5.0 Production


TNS for Linux: Version 10.1.0.5.0 - Production


NLSRTL Version 10.1.0.5.0 - Production


NLSRTL Version 10.1.0.5.0 - Production


JChem version in the database: 3.1.7


JChem version in the Tomcat server: 3.1.7


java.vm.version: 1.5.0_06-b05


java.vm.vendor: Sun Microsystems Inc.


Apache Tomcat/5.5.15





JCHEM_CORE_PKG.GETENVIRONMENT()


--------------------------------------------------------------------------------


Major JDBC version in Tomcat: 10


Minor JDBC version in Tomcat: 2








I'm trying to use the composition and dotDisconnectedFormula on jc_evaluate but I'm getting errors.


This is what I tried.


select jc_evaluate('OC(=O)c1c2ccccc2nc3ccccc13','dotDisconnectedFormula') from dual;


select jc_evaluate('OC(=O)c1c2ccccc2nc3ccccc13','composition') from dual;





This is the error


SQL> select jc_evaluate('OC(=O)c1c2ccccc2nc3ccccc13','dotDisconnectedFormula') from dual;


select jc_evaluate('OC(=O)c1c2ccccc2nc3ccccc13','composition') from dual;select jc_evaluate('OC(=O)c1c2ccccc2nc3ccccc13','dotDisconnectedFormula') from dual


*


ERROR at line 1:


ORA-29532: Java call terminated by uncaught Java exception:


java.lang.RuntimeException: The following exception has been thrown by the


servlet:


Exception: Expression dotDisconnectedFormula yields java.lang.String.


Expressions must yield one single number!


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 61


ORA-06512: at "JCHEM.EVALUATE_FUNC", line 10








SQL>


select jc_evaluate('OC(=O)c1c2ccccc2nc3ccccc13','composition') from dual


*


ERROR at line 1:


ORA-29532: Java call terminated by uncaught Java exception:


java.lang.RuntimeException: The following exception has been thrown by the


servlet:


Exception: Expression composition yields java.lang.String. Expressions must


yield one single number!


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 61


ORA-06512: at "JCHEM.EVALUATE_FUNC", line 10





What am I doing wrong ?


Regards,


Mikael

Hi.


Found out that I was to use jc_evaluate_x instead.


/Mikael