10.8 SET_SESSION_CREDENTIALS Procedure Signature 2

This procedure sets Client ID and Client Secret for a given credential for the current session. Typically used for the OAuth2 Client Credentials flow.

Syntax

PROCEDURE SET_SESSION_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-6 SET_SESSION_CREDENTIALS Procedure Signature2 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 (used for OCI)
p_fingerprint	Optional fingerprint (used for OCI)

Example

The following example sets credential OAuth Login.

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