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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
98 views