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.