2 Replies Latest reply: Mar 1, 2013 2:10 PM by Luis Kefur RSS

    Problem with dbms_lob.substr

    Luis Kefur
      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 on Oracle DB 11g Express Edition Release