ORA-29273 ORA-06512 ORA-29259

ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1722
ORA-29259: end-of-input reached
ORA-06512: at line 1


Error:  ORA-29259  (ORA-29259)
Text:  end-of-input reached
---------------------------------------------------------------------------
Cause: The end of the input was reached.
Action: If the end of the input is reached prematurely, check if the
input source terminates prematurely. Otherwise, close the
connection to the input.





 Please remove any leading or trailing characters (space, enter etc) in the value.


The issue was with proxy setting.
Once the UTL_HTTP.SET_PROXY was set appropriately, I no longer get the end-of-input error.

URL is not properly set



CAUSE

The site that is accessed via utl_http requires mutual authentication.

SOLUTION

This is not possible in 10g . This was implemented in 11g only.

SELECT * FROM DBA_SCHEDULER_JOB_RUN_DETAILS WHERE JOB_NAME = 'LD_AD_IE_SPAN_NSEF_BPL-4' ORDER BY 2 DESC;


SELECT UTL_HTTP.REQUEST ('http://172.168.1.104') FROM DUAL;

SELECT * FROM TABLE(DBMS_NETWORK_ACL_UTILITY.domains('172.168.1.104'));

select utl_http.request('https://marc.charpentier.com/ws/services/Payment?wsdl',NULL,'file:E:\wallet','******') from dual;



recreate ACL privileges