14 Replies Latest reply on Nov 5, 2013 3:53 PM by rp0428

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

    1048939

      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.