EBS Customizations (MOSC)

MOSC Banner

Using UTL_HTTP to call a Webservice from PL/SQL Procedure - Error 403 Forbidden access is denied

edited Jun 2, 2017 5:00AM in EBS Customizations (MOSC) 1 commentAnswered

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="

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