5 Replies Latest reply: Dec 4, 2012 2:43 PM by Solomon Yakobson RSS

    size issue with CLOB

      I have declared var as CLOB, and expected the below UTL_HTTP.write_text(l_http_request, var);

      to work , but I am getting

      ORA-06502: PL/SQL:numeric or value error, So the write_error is causing the issue, should not var, which is CLOB, easily hold 32909 bytes ?

      --- SOME CODE
      UTL_HTTP.set_header(l_http_request, 'Content-Type', 'text/xml');
      UTL_HTTP.set_header(l_http_request, 'Content-Length', LENGTH(var));
      UTL_HTTP.set_header(l_http_request, 'SOAPAction', 'http://SOMEURL');
        -- I print the length of v_var, it is 32909 bytes      
        -- getting ORA-06502: PL/SQL: numeric or value error here
      UTL_HTTP.write_text(l_http_request, var);
      END LOOP;