Skip to content

adm_context_api

This document contains the API documentation for the adm_context_api package.

Establishes a system-level session context The system user has full administrative privileges Run this procedure before any scripts that perform administrative operations

Signature:

procedure system_login (
p_debug_level in apex_debug.t_log_level default apex_debug.c_log_level_warn
);

Parameters:

NameDirectionTypeDescription
p_debug_levelinapex_debug.t_log_level default apex_debug.c_log_level_warnThe debug level to use for logging (increase to c_log_level_info or c_log_level_app_trace)

Establishes a user session context for system operations Use this to run scripts as a specific user and his permissions

Signature:

procedure system_user_login (
p_username in varchar2
);

Parameters:

NameDirectionTypeDescription
p_usernameinvarchar2The username of the user to log in as (has to exist in the database)