Access credentials stored in Oracle wallet from PL/SQL
We have a scenario where we access a 3rd party REST service from PL/SQL code using utl_http.
And we need to pass the basic credentials (username & password) in the http header to access the REST APIs.
Currently we have the credentials (username & password) hard coded in our dev environment.
Can we store these credentials in the Oracle wallet & access them in PL/SQL code into a varchar variable. If yes, how?
Or Oracle Vault is the right thing to use for this purpose?