Oracle9iAS Portal Developer Kit

update_list procedure

Contained in package wwsec_api.

Call this procedure to modify a group.

procedure update_list

(

p_group_id in number,

p_site_id in number default GLOBAL_GROUP,

p_name in varchar2,

p_description in varchar2 default NULL,

p_hidden_group in number,

p_hidden_members in number

);

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_group_id

A unique identifier for a group.

Datatype: in number

p_site_id

A unique identifier for the site in which the group exists.

Note: This parameter is ignored in Oracle9iAS Portal 9.0.2 and later.

Datatype: in number
Default: null

 p_name

The name of the group.

Datatype: in varchar2

p_description

A description of the group.

Datatype: in varchar2
Default: null

 p_hidden_group

Indicates if the new group is hidden from users and groups except those who are owners of the group.

Datatype: in number

p_hidden_members

Indicates whether the members of the group are hidden from each other (but not from owners).

Note: This parameter is ignored in Oracle9iAS Portal 9.0.2 and later.

Datatype: in number

Exceptions:

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

  • If the group name is invalid, INVALID_GRP_NAME_EXCEPTION is raised.

  • If p_name already exists, a GROUP_NOT_UNIQUE_EXCEPTION is raised.

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

Example:

update_list
(

p_groupid => 2,
p_name => ‘DEVELOPER’,
p_description => ‘Development Team’,
p_hidden_group => wwsec_api.NOT_HIDDEN

);

Related topics

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