Oracle9iAS Portal Developer Kit

person_info function (name)

Contained in package wwsec_api.

Call this function to return information about a person when given a user name.

function person_info

(

p_user_name in varchar2

)

return wwsec_person%rowtype;

Version: Oracle Portal 3.0.6.6.5 or later

Parameter:

 p_user_name

The user name for a person.

Datatype: in varchar2

Returns:

This routine returns person information.

Exceptions:

  • If a problem occurs for which an exception has not been defined, an UNEXPECTED_EXCEPTION is raised.

  • If the user name is not found, a USER_NOT_FOUND_EXCEPTION is raised.

Example:

l_person_rec wwsec_person%rowtype;

l_person_rec := wwsec_api.person_info

(

p_user_name => 'USER1'

);

Related topics

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