Oracle9iAS Portal Developer Kit

is_proxy_used_by_providers function

Contained in package wwctx_api_proxy.

Call this function to check whether a the given proxy is used by any providers.

function is_proxy_used_by_providers

(

p_proxy_id in varchar2

)

return boolean;

Version: Oracle9iAS Portal 9.0.2 or later

Parameters:

p_proxy_id

The ID of the proxy required.

Datatype: proxy_record

Returns:

This function returns true if the proxy is used by any providers and false if it is not.

Exceptions:

If an unknown error occurs, PROXY_GENERAL_EXCEPTION is raised.

Example:

l_is_used Boolean;
l_is_used := wwctx_api_proxy.is_proxy_used_by_providers
(

p_proxy_id => '8834567897456aaaaa45678898989456'

);

Related topics

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