checking for compliance of molecule with Index structureType

Dear all

Is there a way how one can check with the cartridge the compliance of a molecular representation with the structure type chosen for a structure index?

In the situation I am now I wish to check before making an insert into a table with a structure index wether the smiles is compliant with the structureType of the index, which is in this case "molecule". The table of interest has not been created with cartridge functions, but has only a structure index created with the cartridge. The structure column is a column with smiles. Any insert of a structure smiles string not compliant with the structureType of the index leads to an SQL error of this statement.

Does the cartdidge proviode an PL/SQL function for a such a compliance check? If not, can such a function be added to cartridge? This would also allow an easy checking for non compliant structures before creation of an index. The function would take the molecular representation and the structure type as parameters an give a yes/no answer whether structure is compliant.

best regards

Ansgar

My environment according to "select jchem_core_pkg.getenvironment() from dual" is:

Oracle environment:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

JChem Server environment:
Java VM vendor: Sun Microsystems Inc.
Java version: 1.6.0_27
Java VM version: 20.2-b06
JChem version: 5.5.0.1
JChem Index version: 5050000
JDBC driver version: 11.1.0.7.0-Production

 

Dear Ansgar,

There is currently no such function. We will get back with more details later.

Peter

Dear Ansgar,

We will provide such a function.

Peter

Dear Ansgar,

The requested PL/SQL function will be provided in version 5.9.

Tamas

The function jcf.insertable with the structure and table data is available in version 5.9.