15.10 SET_SESSION_CREDENTIALS Procedure Signature 1

This procedure sets user name and password for the provided credential for the current Oracle APEX session. Typically used for BASIC authentication when the end user provides the credentials.

Syntax

APEX_CREDENTIAL.SET_SESSION_CREDENTIALS (
    p_credential_static_id  IN VARCHAR2,
    p_username              IN VARCHAR2,
    p_password              IN VARCHAR2 );

Parameters

Parameters	Description
p_credential_static_id	The credential static ID.
p_username	The credential user name.
p_password	The credential password.

Example

The following example sets credential Login.

BEGIN
    apex_credential.set_session_credentials (
        p_credential_static_id => 'Login',
        p_username             => 'scott',
        p_password             => 'tiger );
END;