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!

Good practice to store a password used to consume a webservice

juliojgsJul 10 2018 — edited Jul 10 2018

Hi,

I have a quite simple plsql function in oracle 11g that consumes an external webservice, using apex_web_service.make_request to return the xml payload of the service.

I have to pass a plaintext username and password. This are different accross different deployment environments , along with the endpoints.

I'd like suggestions about good practices to store this credentials into code. Now I have them right there, in package body constants, and it gives me the creeps every time I see it.

Would appreciate at least a better practice than that ... no need to be "the best", or maybe your opinions respect if this is normal or not.

thanks.

This post has been answered by AndrewSayer on Jul 10 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2018
Added on Jul 10 2018
15 comments
2,716 views