Estou tentando fazer uma requisição POST pelo UTL_HTTP, mas estou recebendo a seguinte exception:
-ERROR- ORA-29273: HTTP request failed
ORA-44102: unknown or unsupported algorithm
-DETAILED_ERROR- ORA-44102: unknown or unsupported algorithm
ORA-06512: at line 48
DECLARE
REQ UTL_HTTP.REQ;
RES UTL_HTTP.RESP;
V_URL VARCHAR2 (4000) := 'http://10.60.0.17:8081/manufatura';
V_BUFFER VARCHAR2 (4000);
ERROR_MESSAGE CLOB;
CONTENT VARCHAR2 (4000);
BEGIN
REQ :=
UTL_HTTP.BEGIN_REQUEST (URL => V_URL,
METHOD => 'POST',
HTTP_VERSION => 'HTTP/1.1'
);
UTL_HTTP.SET_HEADER (REQ, 'Content-Type', 'application/json');
UTL_HTTP.WRITE_TEXT (REQ, CONTENT);
RES := UTL_HTTP.GET_RESPONSE (REQ);
DBMS_OUTPUT.ENABLE (100000000);
-- process the response from the HTTP call
DBMS_OUTPUT.PUT_LINE ('RESPONSE: ');
DBMS_OUTPUT.PUT_LINE (RES.STATUS_CODE);
BEGIN
LOOP
UTL_HTTP.READ_LINE (RES, V_BUFFER);
DBMS_OUTPUT.PUT_LINE (V_BUFFER);
END LOOP;
UTL_HTTP.END_RESPONSE (RES);
EXCEPTION
WHEN UTL_HTTP.END_OF_BODY
THEN
UTL_HTTP.END_RESPONSE (RES);
ERROR_MESSAGE := UTL_HTTP.GET_DETAILED_SQLERRM;
DBMS_OUTPUT.PUT_LINE (ERROR_MESSAGE);
DBMS_OUTPUT.PUT_LINE ('1');
END;
EXCEPTION
WHEN OTHERS
THEN
ERROR_MESSAGE := UTL_HTTP.GET_DETAILED_SQLERRM;
DBMS_OUTPUT.PUT_LINE (RES.STATUS_CODE);
DBMS_OUTPUT.PUT_LINE (ERROR_MESSAGE);
RAISE_APPLICATION_ERROR (
-20001,
'An error was encountered - '
|| (CHR (13) || CHR (10))
|| (CHR (13) || CHR (10))
|| SQLCODE
|| (CHR (13) || CHR (10))
|| (CHR (13) || CHR (10))
|| ' -ERROR- '
|| SQLERRM
|| (CHR (13) || CHR (10))
|| (CHR (13) || CHR (10))
|| ' -DETAILED_ERROR- '
|| ERROR_MESSAGE);
END;
A requisição via outra ferramenta como postman funciona perfeitamente.
Alguém pode ajudar por favor?