user_name function

Related topics

Contained in package wwsec_api.

Call this function to return a user name for a specified person ID.

function user_name

(

p_id in number

)
return varchar2;

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_id

A unique identifying number for a person.

Datatype: in number

Returns:

This function returns a user name for the specified ID.

Exceptions:

If the specified person_id does not exist, an INVALID_PERSON_EXCEPTION is raised.

If any other exception condition occurs, an UNEXPECTED_EXCEPTION is raised.

Example:

l_user_name varchar2 (30);

l_user_name := wwsec_api.user_name

(

p_id => 16782

);

Version: Oracle Portal 3.0.6.6.5 or later
Parameters:
p_id	A unique identifying number for a person. Datatype: in number
Returns: This function returns a user name for the specified ID. Exceptions: If the specified person_id does not exist, an INVALID_PERSON_EXCEPTION is raised. If any other exception condition occurs, an UNEXPECTED_EXCEPTION is raised. Example: l_user_name varchar2 (30); l_user_name := wwsec_api.user_name ( p_id => 16782 );

Related topics
Security API packages	PDK PL/SQL API Reference - Home