Skip to Main Content
  • Questions
  • Set up proxy for REST calls in PL/SQL (APEX)

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: March 31, 2021 - 6:09 am UTC

Last updated: March 31, 2021 - 6:39 am UTC

Version: 12c

Viewed 100+ times

You Asked

Hello,

In my company we have a firewall which prevent REST access from one server to another. We need to wait very long time for granting access for particular connection but we can do calls through proxy (we us it in C# app). Is it possible to set proxy in Oracle? We use APEX_WEB_SERVICE.MAKE_REST_REQUEST to connect to servers.

and we said...

Yes, it is right there in the call

SQL> desc APEX_WEB_SERVICE

PROCEDURE MAKE_REQUEST
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 P_URL                          VARCHAR2                IN
 P_ACTION                       VARCHAR2                IN     DEFAULT
 P_VERSION                      VARCHAR2                IN     DEFAULT
 P_COLLECTION_NAME              VARCHAR2                IN     DEFAULT
 P_ENVELOPE                     CLOB                    IN
 P_USERNAME                     VARCHAR2                IN     DEFAULT
 P_PASSWORD                     VARCHAR2                IN     DEFAULT
 P_SCHEME                       VARCHAR2                IN     DEFAULT
 P_PROXY_OVERRIDE               VARCHAR2                IN     DEFAULT  <<====
 P_TRANSFER_TIMEOUT             NUMBER                  IN     DEFAULT
 P_WALLET_PATH                  VARCHAR2                IN     DEFAULT
 P_WALLET_PWD                   VARCHAR2                IN     DEFAULT
 P_HTTPS_HOST                   VARCHAR2                IN     DEFAULT



If you need it for every call, you can also set this at APEX instance level , which is why the parameter above is called "proxy override" (in order to override the instance default if needed)

More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.