problem with cd_id return value?

I seem to be having a problem with the cd_id array variable,


in jchem 5.0.3

Code:

v_cd_id CD_ID_ARRAY := cd_id_array(); ... BEGIN v_cd_id := JC_INSERT     (vMixSmiles,TargetTable,'JCHEMPROPERTIES','true','false',''); EXCEPTION WHEN OTHERS THEN COMMIT; END; IF (v_cd_id (1) > 0) THEN -- cannot get this far sometimes... END IF;

errors out with:





ERROR at line 1:


ORA-06533: Subscript beyond count


ORA-06512: at "VSPACE.VIRTUALSPACEEXPANSIONPCK", line 170


ORA-06512: at line 2





by all accounts the insert has happened OK but not returned a cd_id?





I hear that there has been some issues with the cd_id return value?

Quote:

by all accounts the insert has happened OK but not returned a cd_id?

No, you cannot be sure that the insert was successful, as you swallow any potential exception here:

Code:

EXCEPTION WHEN OTHERS THEN COMMIT; END;