Skip to Main Content

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!

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

1048939Nov 5 2013 — edited Nov 5 2013

Hi,

I'm using the CLOB datatype for one of my columns which contains a huge sql statement running into more than five thousand words. When compiling I get no errors, but when running the proc, I get the below errors:

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

ORA-06512: at "RPT_POSITION_G", line 71

ORA-06512: at line 6

line 71, is the place where I initialize the CLOB variable with the sql statement.

Since, the variable is a CLOB variable, I don't understand why it is saying character string buffer is too small.

The version of the Oracle Database is 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production.

Can someone please point me what is going on here?

Thanks.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 3 2013
Added on Nov 5 2013
14 comments
168,131 views