0 Replies Latest reply: Feb 20, 2013 4:30 AM by 803131 RSS

    apex_web_service.make_rest_request getting ORA-06502

    803131
      Hi all,

      I have in my code something like:

      l_return := apex_web_service.make_rest_request (p_url => l_url , p_http_method => 'POST' , p_body => l_body );

      when length(l_body) = 32869 I get:

      ORA-06502: PL/SQL: numeric or value error: raw variable length too long
      ORA-06512: at "SYS.UTL_RAW", line 327
      ORA-06512: at "APEX_040100.WWV_FLOW_WEB_SERVICES", line 350
      ORA-06512: at "APEX_040100.WWV_FLOW_WEBSERVICES_API", line 149
      ...

      For length(l_body) = 17137 it works fine.

      I think this may be a bug since p_body is a CLOB parameter in the MAKE_REST_REQUEST Function.
      (http://docs.oracle.com/cd/E17556_01/doc/apirefs.40/e15519/apex_web_service.htm#autoId9)

      Running Application Express 4.1.0.00.32

      Thanks,
      Andrei