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

Legend

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