I'm using the following snippet to update MongoDB (Appery) from Oracle:
content := '{"where":"{\"Oracle_ID\":\"'||V_MESSAGE_ID(indx)||'\"}","operations":{"$set":{"MSG_header":"'||V_MSG_HEADER(indx)||'", "MSG_message":"'||V_MMSG_CONTENT(indx)||'", "MSG_status":"'||V_MSG_STATUS(indx)||'"}';
dbms_output.put_line(content);
req := utl_http.begin_request(url, 'PUT',' HTTP/1.1');
UTL_HTTP.set_header(req, 'X-Appery-Database-Id', '53f2dac5e4b02cca64021dbe');
utl_http.set_body_charset(l_http_request, 'UTF-8');
utl_http.set_header(req, 'content-type', 'application/json');
utl_http.set_header(req, 'Content-Length', LENGTH(content));
utl_http.write_text(req, content);
res := utl_http.get_response(req);
BEGIN
LOOP
utl_http.read_line(res, buffer);
dbms_output.put_line(buffer);
END LOOP;
utl_http.end_response(res);
This part used to work fine, until suddenly it gives the error (ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1260 ORA-29261: bad argument).
I was reading this https://community.oracle.com/thread/585169 specially the last post.
My question, in my case, the problem could be on Appery server side ? (That depends on where Apache is installed). What if their support inform me that they tested and everything is working fine. How can I track down this issue?
Many thanks,