Oracle9iAS Portal Developer Kit

get_node function

Related topics

Contained in package wwpro_api_node_registry.

Call this function to return node information for the specified provider. The node information that is returned is for the node where the provider implementation is stored.

function get_node

(

p_provider_id in integer

)

return node_record;

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

Parameters:

p_provider_
id

The ID of the provider from which a node record is returned.

Datatype: in integer

Returns:

This function returns a node_record containing details of the specified node.

Exceptions:

  • If the node for the specified provider ID is not found, a NODE_NOT_FOUND_EXCEPTION is raised.

  • If the specified provider ID is not found, a PROVIDER_NOT_FOUND_EXCEPTION is raised.
  • If an error occurs when retrieving the provider record, a PROVIDER_RETRIEVAL_EXCEPTION is raised.
  • If an error occurs when retrieving the node record, a NODE_RETRIEVAL_EXCEPTION is raised.
  • If an error occurs when retrieving the database link information, a NODE_DB_LINK_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:

l_node_info := wwpro_api_node_registry.get_node

(

p_provider_id => 5629

);

Notes

  • Distributed providers are providers 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

Back to top

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