User 7f33ec9a5c
09-11-2012 20:07:19
===== THE ERROR IS==================
ORA-29902: error in executing ODCIIndexStart() routine
ORA-29540: class chemaxon/jchem/cartridge/JCFunctionsClob does not exist
ORA-06512: at "JCHEM.JCHEM_CLOB_PKG", line 81
ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 372
ORA-06512: at "SENOBASE.STRUCTUREID", line 37
ORA-06512: at line 6
======== THINGS THAT CAUSE THIS ERROR ==============================
--- from the jcart schema, running:
select distinct s_structure_id
from senobase.structure
where jc_compare(s_smiles,'c1ccccc1','t:d tautomerSearch:n') = 1;
--- from any schema, calling a PL/SQL function with the above imbedded SQL
--SO the following PL/SQL generates the above error from anywhere.
CREATE OR REPLACE FUNCTION err_test(vSMILES IN VARCHAR2) RETURN number IS
vStructureID number;
BEGIN
SELECT s_structure_id
INTO vStructureID
FROM SENOBASE.STRUCTURE
WHERE jc_compare(s_smiles,vSMILES,'t:d tautomerSearch:n') = 1;
RETURN vStructureID;
EXCEPTION
WHEN NO_DATA_FOUND THEN
return -1;
end;
/
===========THINGS THAT DO NOT CAUSE THE ERROR ======================
--- from any schema other than JCart, calling
select distinct s_structure_id
from senobase.structure
where jc_compare(s_smiles,'c1ccccc1','t:d tautomerSearch:n') = 1;
-- from any schema other than JCart running:
declare
iD number;
begin
select distinct s_structure_id
into id
from structure
where jc_compare(s_smiles,'c1ccccc1','t:d tautomerSearch:n') = 1;
dbms_output.put_line(id);
end;