16.7 SET_PERSISTENT_CREDENTIALS Procedure Signature 1
This procedure sets provided credential attributes persistently, beyond the current session. Already stored access, refresh or ID tokens for the provided credential are removed.
This procedure sets Client ID
and Client Secret
for a given credential. Typically used for the OAuth2
Client Credentials flow. The new credentials are stored persistently and are valid for all current and future sessions. Stored access, refresh or ID tokens for that credential, will be deleted.
Syntax
PROCEDURE SET_PERSISTENT_CREDENTIALS (
p_credential_static_id IN VARCHAR2,
p_client_id IN VARCHAR2,
p_client_secret IN VARCHAR2,
p_namespace IN VARCHAR2 DEFAULT NULL,
p_fingerprint IN VARCHAR2 DEFAULT NULL );
Parameters
Parameters | Description |
---|---|
p_credential_static_id |
Credential static ID. |
p_client_id |
Use Client ID for OAuth Credentials. Use User OCID for OCI Credentials. |
p_client_secret |
Use Client Secret for OAuth Credentials. Use Private Key for OCI Credentials. |
p_namespace |
Use the Tenancy OCID for OCI Credentials. |
p_fingerprint |
Use the Public Key Fingerprint for OCI Credentials. |
Example 1
The following example sets credential attributes for OAuth Login
.
BEGIN
apex_credential.set_persistent_credentials (
p_credential_static_id => 'OAuth Login',
p_client_id => 'dnkjq237o8832ndj98098-..',
p_client_secret => '1278672tjksaGSDA789312..' );
END;
Example 2
The following example sets credential attributes for OCI Login
.
BEGIN
apex_credential.set_persistent_credentials (
p_credential_static_id => 'OCI Login',
p_client_id => 'ocid1.user.oc1...',
p_client_secret => 'MIIEowIBAAKCAQEAsjhTVL...',
p_namespace => 'ocid1.tenancy.oc1...',
p_fingerprint => 'ff:ff:ee:00:...' );
END;
Parent topic: APEX_CREDENTIAL