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

    APEX Listener 2 CLOB error

    TobiasE
      Hello,

      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).
      >

      Versions:

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

      Thanks,
      Tobias