What exactly is the UTL_HTTP (ORACLE) SET_PROXY Proxy?

1

utl_http.set_proxy ( link ');

In this example what exactly does this proxy address?

I tried the internal IP and it did not work, the infra of my company said to have no "external proxy".

Font

Thank you.

    
asked by anonymous 18.10.2018 / 01:28

1 answer

2

Since the utl_http package is used to access data over the Internet, if you are accessing the Internet through a proxy , in a company eg where this is very common, utl_http will fail, because they try to access the network directly.

Then set_proxy is to inform the utl_http package of proxy settings so that it can access the network, such as proxy server address authentication credentials (user and password), that's all.

The most common format is tul_http.set_proxy('http://102.168.12.12:5678') , that is, the address (can be IP) and the port, when there is no authentication.

If there is authentication, you must enter the user and password before the address, separated by at: utl_http.set_proxy('http://usuario:[email protected]:5678')

Examples here: link

EDIT: in your example: http://pgau:abcd@[email protected]:5678' , means:

  

user: pgau
  password: abcd
  proxy server: 102.168.12.12
  port: 5678

If you do not have a proxy , you do not need to do this

    
18.10.2018 / 03:00