8.5 SET_SESSION_CREDENTIALS Procedure Signature1

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

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;