Inserting with jc_insert and molfile as CLOB

Do you have an example of how to insert a structure using a molfile held as a CLOB within PL/SQL? Currently I have to use the jc_molconvert function to convert my molfile as CLOB to a SMILES string as VARCHAR2 and then use:

Code:

aCDReturn := jchem_table_pkg.jc_insert(vSmiles, 'compounds', 'jchemproperties', 'false', 'false', '');   iCDNum := aCDReturn(1);

However this means I lose some of the richer stereochemistry. I also get a problem if the SMILES string is very long. The documenation for jc_insert states "This function has overloaded version with CLOB and BLOB structure fields" but I'm not sure how to do this.








If I try to use the molfile CLOB directly as below, then I get a PLS-00363 compilation error.

Code:

aCDReturn := jchem_table_pkg.jc_insert(cMolFile, 'compounds', 'jchemproperties', 'false', 'false', '');   iCDNum := aCDReturn(1);

Please, see http://www.chemaxon.com/forum/viewpost17713.html#17713 . Let me know if it doesn't help.