Oracle9iAS Portal Developer Kit

id function

Related topics

Contained in package wwsec_api.

Call this function to return a person ID when given a user name or global unique identifier (GUID).

function id

(

p_user_name in varchar2,

p_userguid in VARCHAR2 default null

)

return number;

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_user_name

The user name of the Oracle Portal user.

Datatype: in varchar2

p_userguid

The global unique identifier (GUID) used to identify the user in OID.

It is an optional parameter and when specified takes precedence over p_user_name.

Note: This parameter is available in Oracle9iAS Portal 9.0.2 or later.

Datatype: in varchar2
Default: null

Returns:

This function returns a person ID.

Exceptions:

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

Example:

l_id number;
l_id := wwsec_api.id
(

p_user_name => 'user1’,
p_userguid => '8A15C57A4C563092E034080020AC0977'

);

Related topics

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