jc_molconvert() error

Hi,





With the jc_molconvert() operator, when I run the SQL





select MOLECULE_NAME ,SMILES , jc_molconvert(SMILES,'mol') as MOL_COLUMN from CHEMLIB





after 100-110 results it throws the following error.





ERROR:





ORA-06502: PL/SQL: numeric or value error: character string buffer too small





ORA-06512: at "JCHEM.MOLCONVERT_FUNC", line 21





The table CHEMLIB has ~1000 molecules. Also the above SQL works well with small number of molecules. Any clue about the possible cause for this error?





thanks





Madhu

Hi Madhu,





jc_molconvert returns VARCHAR2. Chances are that the molfile representation of the structure you are trying to convert exceeds the length limit for VARCHAR2 (4000 character). Please, try jc_molconvertb which returns BLOB.





Peter





PS:


If your original structure is also too large (though unlikely with SMILES), you have to use jc_molconvertbb which takes a BLOB structure and returns BLOB.