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