Using UTL_HTTP to call a Webservice from PL/SQL Procedure - Error 403 Forbidden access is denied
Hi ,
Please could you help that i've created procedure to call soap webservice , got error 403 Forbidden access denied
Oracle Version R12.0.6
DB Version 10.2.0.4
Note: i should use user name and password to access this webservice and it works fine on soapui
I've imported wsdl into soapui --> then put username and password and changed end point to be Middleware Server IP --> then copy this code in below procedure
below is procedure
declare
req UTL_HTTP.REQ;
resp UTL_HTTP.RESP;
soap_req VARCHAR2(32767);
-- city varchar2(250) := 'san francisco';
weathertext VARCHAR2(32767);
begin
soap_req := '<?xml version="1.0" encoding="UTF-8"?><wsdl:definitions name="AssignHardwareSerial" targetNamespace="