Hi Everyone,
I'm new to APEX, so please bear with me as I am learning as I go.
The issue that I am trying to overcome is I'm attempting to call a SOAP webservice; however, I receive an error for Insufficient Privileges. I've tested the endpoint in SOAPUI and Postman, both work as expected. That lead me to read through a stack of forums, and I'm thinking that it is due to the ACL not being configured. If the ACL is the problem could someone please provide guidance on the steps to properly get it setup?
I'm working from a paid instance of APEX on autonomous database, and I've never worked with ACLs before, so I'm not familiar with the process outside of what I've read on various forums and in the Oracle documentation. I just want to make sure I understand it before I mess anything up.
Below is the code that I'm currently using to call the web service that is resulting in the error.
Declare
l_envelope clob;
l_xml XMLTYPE;
l_results varchar2(32767);
BEGIN
l_envelope := '<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://www.northgate-is.com/proiv/webservices/types">
<soapenv:Header/>
<soapenv:Body>
<typ:GetJob>
<Authorization_ID>[Auth ID]</Authorization_ID>
<GUID>[Random GUID]</GUID>
<pCompany_Code>[Company Code]</pCompany_Code>
<pDivision>?</pDivision>
<pStatus_Code>?</pStatus_Code>
<pProject_Manager>?</pProject_Manager>
<pSuperintendent>?</pSuperintendent>
<pEstimator>?</pEstimator>
<pCustomer_Code>?</pCustomer_Code>
<pCost_Center>?</pCost_Center>
<pSort_By>?</pSort_By>
</typ:GetJob>
</soapenv:Body>
</soapenv:Envelope>';
l_xml := apex_web_service.make_request(
p_url => 'https://[company address].dexterchaney.com:8482',
p_action => 'https://[Company Address].dexterchaney.com:8482/ws/GetJob',
p_envelope => l_envelope
);
DBMS_OUTPUT.put_line('l_xml=' || l_xml.getClobVal());
end;
Thank you in advance for any information, or guidance on how to resolve!
Best - T