Error with jc_contains or jc_tanimoto

select cd_id, cd_smiles from structures where jc_contains(cd_smiles,'c1cccccc1')=1;





ORA-20101:Please, create domain index on the column referenced in the operator jc_contains of the table with DATA_OBJECT_ID=35645. You can find out the name of the table by executing:


SELECT owner, object_name INTO schema_name,table_name FROM sys.dba_objects WHERE DATA_OBJECT_ID = 35645


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


ORA-06512: at "JCHEM.CONTAINS_FUNC",line 7





JCHEM version 3.0

Create a jc_idxtype index on the cd_smiles column of the structures table (http://www.jchem.com/doc/guide/cartridge/index.html#index).

It works perfectly.