Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CLOB to VARCHAR2 conversion and limit of 8192 chars

500591Jun 12 2006 — edited Jun 14 2006

Hello, I have the folowing code which works on Oracle 10g SE but does not on XE:

DECLARE
    d1 varchar2(32000);
BEGIN
    d1 := to_char(substr(MY_FUNC_RETURNING_CLOB, 1, 8192));
END;

This ends with "ORA-06502: PL/SQL: numeric or value error." Only CLOBs shorter then 8192 works... (well the SUBSTR function is there just because of testing the maximum length of CLOB that does not fail).

Is this my mistake, a bug in XE or some XE limitation (using UTF-8 version of XE)?

Thanks for any hints!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 12 2006

Added on Jun 12 2006

4 comments

2,493 views