PL/SQL (MOSC)

MOSC Banner

Calling REST service using PL/SQL

edited Jul 1, 2020 5:06AM in PL/SQL (MOSC) 9 commentsAnswered

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');

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center