10.3 SET_PERSISTENT_CREDENTIALS Procedure Signature 1

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

Table 10-2 SET_PERSISTENT_CREDENTIALS Procedure Signature 1 Parameters

Parameters	Description
p_credential_static_id	The credential static ID.
p_client_id	The OAuth2 Client ID.
p_client_secret	The OAuth2 Client Secret
p_namespace	Optional namespace (for OCI)
p_fingerprint	Optional fingerprint (for OCI)

Example

The following example sets credential OAuth Login.

begin
    apex_credential.set_persistent_credentials (
    p_credential_static_id  => 'OAuth Login',
    p_client_id             => 'dnkjq237o8832ndj98098-..',
    p_client_secret         => '1278672tjksaGSDA789312..' );
end;