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;