find_node function (by name)

Related topics

Contained in package wwpro_api_node_registry.

Call this function to return the details of a registered node. Both node record and database link information are retrieved, excluding the host_portal_passwd field.

function find_node

(

p_name in varchar2

)

return node_record;

Any user can execute this function.

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

Parameters:

p_name

The name of the node to be returned.

Datatype: varchar2

Returns:

This function returns a node record containing all the properties of the remote node.

Exceptions:

If the node with the specified node name is not found, a NODE_NOT_FOUND_EXCEPTION is raised.

If an error occurs when retrieving the node with the specified node name, a NODE_RETRIEVAL_EXCEPTION is raised.

If an error occurs when retrieving the database connection 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.find_node

(

p_name => 'PORTAL30'

);

Note

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.

Version: Oracle Portal 3.0.6.6.5 or later Deprecated: Oracle9iAS Portal 9.0.2
Parameters:
p_name	The name of the node to be returned. Datatype: varchar2
Returns: This function returns a node record containing all the properties of the remote node. Exceptions: If the node with the specified node name is not found, a NODE_NOT_FOUND_EXCEPTION is raised. If an error occurs when retrieving the node with the specified node name, a NODE_RETRIEVAL_EXCEPTION is raised. If an error occurs when retrieving the database connection 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.find_node ( p_name => 'PORTAL30' );

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