10.4 SET_PERSISTENT_CREDENTIALS Procedure Signature 2

This procedure sets username and password for a given credential. This is typically be used by a security person after application import, and allows to separate responsibilities between a person importing the application and another person storing the credentials.

Syntax

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

Parameters

Table 10-3 SET_PERSISTENT_CREDENTIALS Procedure Signature 2 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_persistent_credentials (
    p_credential_static_id => 'Login',
    p_username             => 'scott',
    p_password             => 'tiger );
end;