SQL & PL/SQL

create or replace
Function WSIACALL_t12
RETURN number
IS
/*
DECLARE
  v_Return NUMBER;
BEGIN

  v_Return := WSIACALL_T12();
  DBMS_OUTPUT.PUT_LINE('v_Return = ' || v_Return);
END;
*/
L_ERROR_MSG_V VARCHAR2(1000);
L_ERR_CHK VARCHAR2(32767);
L_MY_SCHEME VARCHAR2(256);
L_MY_REALM VARCHAR2(256);
L_MY_PROXY BOOLEAN;
L_WS_URL VARCHAR2(256);
USERNAME VARCHAR2(256);
PASSWORD1 VARCHAR2(256);
L_ENV_V VARCHAR2(32767);
L_WSV_RESP_XML XMLTYPE;
HTTP_REQ UTL_HTTP.REQ;
HTTP_RESP UTL_HTTP.RESP;
FAULT_ERROR EXCEPTION;

BEGIN
L_WS_URL := 'http://192.168.100.29/WSIA/index.php?wsdl';
USERNAME := '@bility1';
PASSWORD1 := '@bility123';
L_ENV_V := '<soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:SPSWSDL" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"><soapenv:Header/><soapenv:Body><urn:ProvSubsManagementRequest soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"><ProvRequest xsi:type="urn:ProvReq"><Username xsi:type="xsd:string">@bility1</Username><Password xsi:type="xsd:string">@bility123</Password><ReqType xsi:type="xsd:string">S</ReqType><Prior xsi:type="xsd:string">L</Prior><ReqNo xsi:type="xsd:long">63</ReqNo><GParam xsi:type="urn:GParam" soapenc:arrayType="wsdl:Param[6]" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"><item xsi:type=":Param"><Key xsi:type="xsd:string">SC</Key><Val xsi:type="xsd:string">FXL</Val></item><item xsi:type=":Param"><Key xsi:type="xsd:string">SS</Key><Val xsi:type="xsd:string">General</Val></item><item xsi:type=":Param"><Key xsi:type="xsd:string">CT</Key><Val xsi:type="xsd:string">N</Val></item><item xsi:type=":Param"><Key xsi:type="xsd:string">ACCNO</Key><Val xsi:type="xsd:string">9869898</Val></item><item xsi:type=":Param"><Key xsi:type="xsd:string">NM</Key><Val xsi:type="xsd:string">1473555</Val></item><item xsi:type=":Param"><Key xsi:type="xsd:string">SN</Key><Val xsi:type="xsd:string">6</Val></item></GParam><Cmds xsi:type="urn:Cmds" soapenc:arrayType="wsdl:Cmd[1]" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"><item xsi:type=":Cmd"><Action xsi:type="xsd:string">OPLN</Action><LParam SOAP-ENC:arrayType=":Param[8]"><item xsi:type=":Param"><Key xsi:type="xsd:string">AC</Key><Val xsi:type="xsd:string">01</Val></item><item xsi:type=":Param"><Key xsi:type="xsd:string">IT</Key><Val xsi:type="xsd:string">PB</Val></item><item xsi:type=":Param"><Key xsi:type="xsd:string">EXC</Key><Val xsi:type="xsd:string">10</Val></item><item xsi:type=":Param"><Key xsi:type="xsd:string">SH</Key><Val xsi:type="xsd:string">1</Val></item><item xsi:type=":Param"><Key xsi:type="xsd:string">MN</Key><Val xsi:type="xsd:string">10</Val></item><item xsi:type=":Param"><Key xsi:type="xsd:string">PT</Key><Val xsi:type="xsd:string">8</Val></item><item xsi:type=":Param"><Key xsi:type="xsd:string">ACT</Key><Val xsi:type="xsd:string">1</Val></item><item xsi:type=":Param"><Key xsi:type="xsd:string">ACR</Key><Val xsi:type="xsd:string">1</Val></item></LParam></item></Cmds></ProvRequest></urn:ProvSubsManagementRequest></soapenv:Body></soapenv:Envelope>';

HTTP_REQ := UTL_HTTP.BEGIN_REQUEST('L_WS_URL', 'POST');
UTL_HTTP.SET_AUTHENTICATION(HTTP_REQ,USERNAME,PASSWORD1);
UTL_HTTP.SET_HEADER(HTTP_REQ, 'Content-Type', 'text/xml');
UTL_HTTP.SET_HEADER(HTTP_REQ, 'Content-Length',LENGTH(L_ENV_V));
UTL_HTTP.SET_HEADER(HTTP_REQ, 'SOAPAction', 'ProvSubsManagementRequest');
UTL_HTTP.WRITE_TEXT(HTTP_REQ,L_ENV_V);
HTTP_RESP := UTL_HTTP.GET_RESPONSE(HTTP_REQ);

RETURN 1;
dbms_output.put_line(SQLERRM);

EXCEPTION
WHEN OTHERS THEN
raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);
end;




DECLARE
  v_Return NUMBER;
BEGIN

  v_Return := WSIACALL_T12();
  DBMS_OUTPUT.PUT_LINE('v_Return = ' || v_Return);
END;
Error report:
ORA-20001: An error was encountered - -29273 -ERROR- ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "MIG_STG.WSIACALL_T12", line 46
ORA-06512: at line 5