Oracle9iAS Portal Developer Kit

sync_providers procedure

Contained in package wwpro_api_node_registry.

Call this procedure to update the local node with both remote node name changes and remote node provider list changes.

Note: This method does not update the portlet repository.

procedure sync_providers;

A user must have the All Provider Manage or All Provider Publish privilege to synchronize node providers.

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

Exceptions:

  • If the user does not have the appropriate privilege to synchronize remote providers, a wpro_api_provider.PROVIDER_SECURITY_EXCEPTION is raised.

  • If one or more database links are invalid, an INVALID_DBLINKS_FOUND_EXCEPTION is raised.

Note: This and other provider node APIs add error messages to the error stack before they raise exceptions. This allows users to interrogate the error stack if a problem occurs.

Example:

wwpro_api_node_registry.sync_providers;

Notes

  • Distributed providers are providers that exist on remote nodes.

  • A database link is an object stored in the local database that identifies a remote database, a communication path to the remote database, and, optionally, a username and password for it. Once defined, the database link is used to perform queries on tables in the remote database.

Related topics

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