Access Secrets from Oracle Key Vault (OKV) in PL/SQL - Oracle Database 19c - on-premises
Hi everyone,
I’m trying to securely retrieve secrets (like passwords and API keys) stored in Oracle Key Vault
directly in PL/SQL packages or procedure. I've conducted a basic POC , and was able to retrieve the secrets successfully using OKV's REST service commands. However I'm looking for a way to retrieve okv secrets in PL/SQL objects.
- Is it possible to access OKV secrets directly from PL/SQL? If so, any examples or documentation would be helpful.
- If not, what’s the recommended way to securely retrieve and use OKV secrets in PL/SQL? For instance, would using Oracle Wallets or an external procedure be a best practice? Any specific guidance or examples on this would be much appreciated!