Error in jc_molconvert ???

User 77bcbbb206

25-07-2005 23:15:13

When using cartridge 3.0.8 with Tomcat 4.1, the jc_molconvert for large smile strings gives an error.





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


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





This is the query:





set serveroutput on


declare


v_out VARCHAR2(32000);


begin


select jc_molconvert(CD_SMILES, 'sdf -2') into v_out from RMS_STRUCTURE where cd_id = 34864;


dbms_output.put_line(v_out);


exception


when others then


dbms_output.put_line(sqlerrm);


end;


/





where cd_id 34864's smile string is "CCCCCCCCCCCCCCCCCC(=O)NC(COC1O[C@H](CO)[C@@H](O[C@@H]2O[C@H](CO)[C@H](O)[C@H](O)[C@H]2O)[C@H](O)[C@H]1O)C(O)CCCCCCCCCCCCCCC"





Is this an expected behavior from such a large molecule? Should I be using a different function?





Thanks.

User 77bcbbb206

26-07-2005 00:04:38

Sorry. I answered my own questions. I guess I should read more before I ask.





http://www.chemaxon.com/forum/ftopic758.html