| get_db_user function

Related topics
Contained in package wwctx_api. Call this function to get the Oracle database user name that corresponds to the current Oracle Portal user (as determined by the SSO cookie). Note: The database user is the schema that contains and executes all required PL/SQL code for the current, logged in, Oracle Portal user. function get_db_user return varchar2;

Version: Oracle Portal 3.0.6.6.5 or later
Returns: This function returns the database user name for the current, logged in Oracle Portal user. Exceptions: If no session was found, a NO_SESSION_EXCEPTION is raised. If an undefined error occurs, a GENERAL_CONTEXT_EXCEPTION is raised. Example: This example returns the database user_id for the database user name of the current Oracle Portal user. declare v_userid number; begin select user_id into v_userid from all_users where user_name = wwctx_api.get_db_user; return v_userid; end;

Related topics
Session context API package | PDK PL/SQL API Reference - Home

Back to top
The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio