Oracle9iAS Portal Developer Kit

node_record record structure and tables

The wwpro_api_node_registry API package contains the node_record record structure. This structure contains the properties of the local node and of remote nodes than can be registered.

The node_record structure is:

type node_record is record

(

id number,

name varchar2(200),

dad_name varchar2(64),

db_link varchar(120),

local boolean,

http_listener_host varchar2(120),

http_listener_port number,

connect_type varchar2(10),

connect_identifier varchar2(200),

db_host_address varchar2(120),

db_host_port number,

db_host_service_name varchar2(200),

host_portal_user varchar2(30),

host_portal_passwd varchar2(200)

);

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

Field names and definitions

id

The node ID.

Note: The node ID is unique across all distributed nodes.

Datatype: number

name

A name for the node.

For the local node, only the node name is modifiable. Remote node names are retrieved from the remote nodes during registration and synchronization.

Note: The node name must be unique across all distributed nodes.

Datatype: varchar2

dad_name

The Data Access Descriptor for the remote node's Listener.

Note: This field is used to form the HTTP call to the provider APIs.

Datatype: varchar2

http_listener_host

The address for the remote node's Listener.

Note: This field is used to form the HTTP call to the provider APIs.

Datatype: varchar2

http_listener_port

The port for the remote node's Listener.

Note: This field is used to form the HTTP call to the provider APIs.

Datatype: number

db_link

The name of the database link.

If the remote database enforces global naming, then the database link name must match the remote database's global database name.

If this field is left blank, then the node's name is used for the link name.

Note: If the database link name does not contain the database domain, the domain name will be automatically appended to it.

Datatype: varchar

local

A flag that indicates if the node is the local node or a remote node.

Note: Because the local field cannot be modified, the local field is not used by register and edit methods.

Datatype: Boolean

connect_type

An identifier that indicates how the database links for remote nodes are created: as Net8 connect identifiers or as a Net8 connect descriptors.

Datatype: varchar2

connect_identifier

The Net8 connect identifier used when creating a database link.

Note: This field is valid when the connection type specified is connect identifier.

Datatype: varchar2

db_host_address

The host address for the remote node.

Notes:

  • The db_host_address is used with db_host_port and db_host_service_name to form the connect descriptor.

  • The connect descriptor is used for database link creation.
  • This field is valid when the connection type specified is connect descriptor.

Datatype: varchar2

db_host_port

The host port for the remote node.

Notes:

  • The db_host_port is used with the db_host_address and db_host_service_name to form the connect descriptor. The connect descriptor is used for database link creation.

  • This field is valid when the connection type specified is connect descriptor.

Datatype: number

db_host_service_name

The host service name for the remote node.

Notes:

  • This value is used with the db_host_address and db_host_port to form the connect descriptor.

  • The connect descriptor is used for database link creation.
  • This field is valid when the connection type specified is connect descriptor.

Datatype: varchar2

host_portal_user

The name of schema that owns the host's Oracle Portal.

Notes:

  • This value is used for database link creation.

  • This field is valid for both connection types.

Datatype: varchar2

host_portal_passwd

The password for the host_portal_user.

Note: This value is used for database link creation.

Datatype: varchar2

The node table

type node_table is table of node_record index by binary_integer.

The node ID table

type node_id_table is table of number index by binary_integer.

Note

Distributed nodes are accessible nodes on remote Oracle Portal installations. 

Related topics

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