Oracle9iAS Portal Developer Kit

lists function

Contained in package wwsec_api.

Call this function to return a list of group IDs for the 'LIST' type groups that exist within a site, when given a site ID.

function lists

(

p_siteid in number default null

)

return wwsec_api.list_array;

 

type list_record is record

(

group_id wwsec_group$.id%type,

siteid wwsec_group$. site_id%type,

name wwsec_group$.name%type,

description wwsec_group$.description%type

);

type list_array is table of list_record index by binary_integer;

 

 

Version: Oracle Portal 3.0.6.6.5 or later
Deprecated: Oracle9iAS Portal 9.0.2

Parameters:

 p_siteid

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

Datatype: in number
Default: null

Returns:

This function returns a list of groups of type 'LIST' in the array of list_record.

Exceptions:

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

Example:

l_listarray wwsec_api.list_array;

l_listarray := wwsec_api.lists

(

p_siteid => 13

);

Related topics

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