Thursday, October 22, 2015

PL/SQL How to set proxy to access URL



Below is script to set proxy from DB session in PL/SQL.


    BEGIN
      --
      UTL_HTTP.SET_PROXY('<IP Address>', NULL);
      UTL_HTTP.SET_PERSISTENT_CONN_SUPPORT(TRUE);
      --
    END;


Once proxy is set, you can check access for particular URL using below SQL statement,

select utl_http.request('<URL>')
  from dual;

No comments:

Post a Comment