This discussion is archived
1 Reply Latest reply: Jan 15, 2013 12:31 PM by Colm Divilly RSS

APEX Listener 2 CLOB error

TobiasE Newbie
Currently Being Moderated

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



  • Correct Answers - 10 points
  • Helpful Answers - 5 points