Oracle9iAS Portal Developer Kit

db_user function

Contained in package wwsec_api.

Call this function to return a database user name when given the name of an Oracle Portal user.

function db_user

(

p_user_name in varchar2

)

return varchar2;

Version: Oracle Portal 3.0.6.6.5 or later

Parameter:

p_user_name

The name of an Oracle Portal user.

Datatype: in varchar2

Returns:

This function returns the name of a database user.

Exceptions:

  • If the p_user_name parameter is not found, a USER_NOT_FOUND_EXCEPTION is raised.

Example:

l_dbuser varchar2;

l_dbuser := wwsec_api.db_user

(

p_user_name => 'USER1'

);

Related topics

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