Calling REST service using PL/SQL
Hi Team,
I am trying to invoke the fusion HCM DOR REST web service using PL/SQL but getting the following error.
Error:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-28860: Fatal SSL error
ORA-06512: at line 9
Kindly help me for the same.
declare
l_url varchar2(100) := 'https://XXX-XXX.fa.em3.oraclecloud.com/hcmRestApi/resources/11.13.18.05/documentRecords';
l_req utl_http.req;
l_result utl_http.resp;
l_data varchar2(32767);
content varchar2(4000) := '{"PersonNumber": "T01","DocumentCode": "Payslip-Mar20","DocumentName": "Payslip-Mar20","DocumentType": "Third Party Payslip"}';
begin
--utl_http.set_wallet('file:C:\Users\krishna.palanikumar\Desktop\Certificate');
l_req := utl_http.begin_request(l_url,'POST',' HTTP/1.1');