Technology Stack - EBS (MOSC)

MOSC Banner

Call HTTP End Points from Applications Node

EBS 12.2.10

Database 19c (19.18.0.0.0)

Below http request is working fine on DB node. I want to call below http request from application node. Is there any possibility to do this ? What could be mechanism in this case?

DECLARE
req UTL_HTTP.REQ;
resp UTL_HTTP.RESP;
name VARCHAR2(256);
value VARCHAR2(1024);
BEGIN
UTL_HTTP.SET_PROXY('','');
req := UTL_HTTP.BEGIN_REQUEST('google.com');
--UTL_HTTP.SET_HEADER(req, 'User-Agent', 'Mozilla/4.0');
resp := UTL_HTTP.GET_RESPONSE(req);
DBMS_OUTPUT.PUT_LINE('HTTP response status code: ' || resp.status_code);
DBMS_OUTPUT.PUT_LINE('HTTP response reason phrase: ' || resp.reason_phrase);

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