Oracle9iAS Portal Developer Kit

add_group_to_list procedure

Contained in package wwsec_api.

Call this procedure to add a group as a member of another group and set privileges if the former group is specified to be an owner of the latter group.

procedure add_group_to_list

(

p_group_id in number,

p_to_group_id in number,

p_is_owner in number

);

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_group_id

The unique identifier of the group to be added.

Datatype: in number

p_to_group_id

The unique identifier of the 'LIST' type group to which p_group_id will be added.

Datatype: in number

p_is_owner

Indicates whether p_group_id is to be an owner of p_to_group_id.

Note: Valid values are OWNER (1) and NOT_OWNER (0).

Datatype: in number

Exceptions:

  • If p_group_id does not exist, a GROUP_NOT_FOUND_EXCEPTION is raised.

  • If the group being added is already a member of the list, a GROUP_MEMBER_EXCEPTION is raised.

  • If the user who initiates the calling routine has insufficient authority to execute the routine, an ACCESS_DENIED_EXCEPTION is raised.

  • If the group gets referenced back to itself at some point in the group membership chain, CIRCULAR_REFERENCE_EXCEPTION is raised.

Example:

wwsec_api.add_group_to_list

(

p_group_id => 243,

p_to_group_id => 32,

p_is_owner => wwsec_api.owner

);

Related topics

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