11.9 SET_SESSION_CREDENTIALS Procedure Signature 1

This procedure sets username and password for a given credential for the current session. Typically used for BASIC authentication when the credentials to be used are to be provided by the end user.

Syntax

PROCEDURE SET_SESSION_CREDENTIALS(
    p_credential_static_id  IN VARCHAR2,
    p_username              IN VARCHAR2,
    p_password              IN VARCHAR2 );

Parameters

Table 11-7 SET_SESSION_CREDENTIALS Procedure Signature1 Parameters

Parameters	Description
p_credential_static_id	The credential static ID.
p_username	The credential username.
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;