SET_SESSION_CREDENTIALS Procedure Signature 2

This procedure sets provided credential attributes for the current Oracle APEX session. Typically used for the OAuth2 client credentials or OCI (Oracle Cloud Infrastructure) credential types.

Syntax

APEX_CREDENTIAL.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

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_session_credentials (
        p_credential_static_id => 'OAuth Login',
        p_client_id            => 'dnkjq237o8832ndj98098-..',
        p_client_secret        => '1278672tjksaGSDA789312..' );
END;

Example 2

The following example sets the credential attributes for OCI Login.

BEGIN
    apex_credential.set_session_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;