jc_xxxx vs jc_xxxxb

User 9912280a1f

22-06-2006 13:39:37

Hi,





Just wondering if there is any advantage over using the jc_xxxx function compared to the jc_xxxxb version? Are the string and blob versions provided simply for flexibility?





Cheers





Paul

ChemAxon aa7c50abf8

22-06-2006 13:47:50

Hi Paul,
Quote:
Are the string and blob versions provided simply for flexibility?
Yes. The blob versions are there in case the size limit of the varchar2 datatype (4000 in the database, over 32000 in PL/SQL) becomes effective for your particular needs.





Cheers,


Peter