SQL & PL/SQL

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!

Oracle error while using function dbms_lob.substr()

Shine HaridasanMar 15 2012 — edited Mar 16 2012

Following sql statement is causing error select dbms_lob.substr(clob_colum,32767) from Table* when the size of clob_column goes above 4 KB. The error message is given below

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

The issue is getting resolved when reducing the size of the CLOB column.

Is this a limitation of oracle query? Can anybody please help me to resolve this error? Thanks in Advance.

Regards,
Shine

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 13 2012

Added on Mar 15 2012

#sql

6 comments

1,267 views