Using CLOB datatype with JC_INSERT function

Hi





The Developer's Guide - Cartridge API describes the JC_INSERT function as having an overloaded version with CLOB and BLOB structure fields. Please could you let me know where I can find the list and order of parameters for using CLOB structure fields? I would like to call the function from PL/SQL to insert a CLOB from another data source.





I can insert a SMILES string into my table (named COMMOUNDS) using

Code:

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

but if I attempt to insert the CLOB:

Code:

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

I receive a compilation error of "PLS-00363: expression 'compounds' cannot be used as an assignment target". Is the list of parameters different for the overloaded function spec?





Many thanks.

This problem has been fixed in JChem version 5.0.3. Until you upgrade, the workaround is to pass the 'compound' string in a variable to jc_insert, not as a string constant. (And yes the parameter list was different.)





Thanks


Peter