get_provider_list function

Related topics

Contained in package wwpro_api_provider_registry.

Call this function to return a list of all providers that match a specified name string. You can include the SQL matching (wild card) characters % and _ in the name string.

function get_provider_list

(

p_name in varchar2,

p_start_row in integer default 1,

p_row_count in integer default 100,

p_language in varchar2 default null

)

return node_provider_rec_table;

Any user can execute this function.

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_name

A name string to be used as a search pattern.

Datatype: in varchar2

p_start_row

A number for the first row in the requested table.

It parameter allows for pagination.

Datatype: in integer
Default: 1

p_row_count

The maximum number of rows for the requested table.

It parameter allows for pagination.

Datatype: in integer
Default: 100

p_language

A constant that specifies the language for the returned translatable strings.

Datatype: in varchar2
Default: null

Returns:

This function returns node_provider_rec_table, a list of all portlet providers that match the search string.

Exceptions:

This function raises no user-defined exceptions.

Example:

l_provider_list := wwpro_api_provider_registry.get_provider_list

(

p_name => 'Portal%',

p_start_row => 1,

p_row_count => 10,

p_language => wwnls_api.AMERICAN

);

Version: Oracle Portal 3.0.6.6.5 or later
Parameters:
p_name	A name string to be used as a search pattern. Datatype: in varchar2
p_start_row	A number for the first row in the requested table. It parameter allows for pagination. Datatype: in integer Default: 1
p_row_count	The maximum number of rows for the requested table. It parameter allows for pagination. Datatype: in integer Default: 100
p_language	A constant that specifies the language for the returned translatable strings. Datatype: in varchar2 Default: null
Returns: This function returns node_provider_rec_table, a list of all portlet providers that match the search string. Exceptions: This function raises no user-defined exceptions. Example: l_provider_list := wwpro_api_provider_registry.get_provider_list ( p_name => 'Portal%', p_start_row => 1, p_row_count => 10, p_language => wwnls_api.AMERICAN );

Related topics
Provider registry API package	PDK PL/SQL API Reference - Home