provider_exist function

Related topics

Contained in package wwpro_api_provider_registry.

Call this function to determine if the provider with a given name exists.

function provider_exist
(

p_name in varchar2,
p_node_id in integer default null

)
return boolean;

Any user can execute this function.

Version: Oracle Portal 3.0.8

Parameter:

p_name

A name string to be used as a search pattern. For example:

l_p_exist boolean;
l_p_exist := wwpro_api_provider_registry.provider_exist('EXAMPLE');
l_p_exist := wwpro_api_provider_registry.provider_exist('EXample');
l_p_exist := wwpro_api_provider_registry.provider_exist('example');

All the above return the same value.

Note: The search is not case sensitive. The search does not provide for wild character searches, e.g. *.

Datatype: in varchar2

p_node_id

Not used in Oracle9iAS Portal 9.0.2 or later.

Leave null.

Returns:

This function returns TRUE if p_name exists. Otherwise, it returns FALSE.

Exceptions:

This function raises no exceptions.

Example:

if wwpro_api_provider_registry.provider_exist

(p_name =>'Example')

then

dbms_output.put_line('Provider Example exists');

end if;

Version: Oracle Portal 3.0.8
Parameter:
p_name	A name string to be used as a search pattern. For example: l_p_exist boolean; l_p_exist := wwpro_api_provider_registry.provider_exist('EXAMPLE'); l_p_exist := wwpro_api_provider_registry.provider_exist('EXample'); l_p_exist := wwpro_api_provider_registry.provider_exist('example'); All the above return the same value. Note: The search is not case sensitive. The search does not provide for wild character searches, e.g. *. Datatype: in varchar2
p_node_id	Not used in Oracle9iAS Portal 9.0.2 or later. Leave null.
Returns: This function returns TRUE if p_name exists. Otherwise, it returns FALSE. Exceptions: This function raises no exceptions. Example: if wwpro_api_provider_registry.provider_exist (p_name =>'Example') then dbms_output.put_line('Provider Example exists'); end if;

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