Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can I store securely proxy user password to use in p_proxy_override for Oracle APEX_WEB_SERVICE.MAKE_REST_REQUEST?

bydmanNov 28 2024

I call an external HTTP API endpoint from the inside our comapny's network. I use Oracle APEX function:

apex_web_service.make_rest_request 
(p_url => l_url 
,p_http_method => 'POST' 
,p_body => request_body_v 
,p_transfer_timeout => 10 
,p_proxy_override => 'my-domain\my-user:my-password@proxy.my-domain.local');

How can I store securely my-user and my-password and refer to them in p_proxy_override parameter? Want to avoid to put it in clear text.

If I use 'my-domain\my-user:my-password@proxy.my-domain.local' in clear text then I get response but this unacceptable for security reasons Where/how can I store these credentials and then refer to them in the p_proxy_parameter?

Comments
Post Details
Added on Nov 28 2024
1 comment
547 views