1 Reply Latest reply on Jan 15, 2013 8:31 PM by Colm Divilly-Oracle

    APEX Listener 2 CLOB error


      I use the "Media Resource" RESTful service type to generate custom JSON objects via CLOB-returning functions. This worked great in APEX Listener 1.1.3. However, on APEX Listener 2.0 I get status 500 on a RESTful service which works fine on 1.1.3 (which generates a clob > 4000 bytes), and the following in the server log:
      SEVERE: ORA-22922: nonexistent LOB value
      oracle.dbtools.common.UnrecoverableException: ORA-22922: nonexistent LOB value
      This seems to be the same issue as reported here:

      APEX Listener EA2 Standalone CLOB error

      As stated by thoechst in that thread:

      It is as though the function is getting cast as a varchar2 somewhere. I verified that the function will correctly return a large result to other sources (dbms_output, for instance).


      APEX Listener 2.0
      WebLogic 10.3.6 on Windows 2008 SE R2 x64
      Oracle DB