2 Replies Latest reply: Mar 1, 2013 12:10 PM by 716769 RSS

    Problem with dbms_lob.substr

    716769
      I have a classic report using
      select column_a, column_b, dbms_lob.substr(column_c,4000,1) column_c from my_table;
      When the column_c is greater than 4000 by, the report gives error ORA-06502.
      I'm using APEX 4.2.0.00.27 on Oracle DB 11g Express Edition Release 11.2.0.2.0.

      Luis.