|
In the wwpro_api_provider_registry
API package, the node_provider_record record contains the properties
of a provider and its corresponding node.
The node_provider_record record structure is:
type node_provider_record is record
(
id number(9),
name varchar2(200),
display_name long,
node_id number,
timeout number,
timeout_msg_id number,
timeout_msg long,
implementation_style number,
implementation_owner varchar2(30),
implementation_name varchar2(2000),
language varchar2(30),
enable_distribution boolean,
login_frequency char(1),
http_url varchar2(1024),
same_cookie_domain Boolean
require_proxy Boolean,
require_session_data Boolean,
is_offline Boolean
http_app_type varchar2(30),
http_app_id varchar2(80),
provider_key varchar2(80),
node_name varchar2(200),
dad_name varchar2(64),
db_link varchar2(120),
local Boolean,
http_listener_host varchar2(120),
http_listener_port number,
created_on date,
created_by varchar2(30),
last_updated_on date,
last_updated_by varchar2(30),
service_id varchar2(1000),
midtier_proxy_hostname varchar2(2000),
midtier_proxy_portnumber number,
dbtier_proxy_hostname varchar2(2000),
dbtier_proxy_portnumber number
);
|
Version: Oracle Portal 3.0.6.6.5 or
later
|
|
Field names and definitions
|
|
id
|
This identifier for the provider is allocated by Oracle Portal
and is unique for each provider and also across a distributed Oracle
Portal system.
Note: A null value is not permitted.
Datatype: number
|
|
name
|
A name for the provider.
This provider name is not translated, can be used during searching,
and is presented in the UI when Oracle Portal is required to list
providers.
Note:The name returned is not sensitive to the language and
a null value is not permitted.
Datatype: varchar2
|
|
display_name
|
A translatable string for the provider name. This string is sensitive
to the language parameter. Oracle Portal can use this name when
displaying provider information.
Datatype: long
|
|
node_id
|
A unique identifier for the node (Oracle Portal installation).
Note: The node ID is unique across distributed provider nodes.
Datatype: number
|
|
timeout
|
The default number of seconds that the Oracle Portal should try
to connect to this provider before displaying a timeout message.
Note: Oracle Portal first attempts to retrieve a timeout value
from the portlet, then from the provider. If both attempts fail,
it uses the Oracle Portal default timeout value.
Datatype: number
|
|
timeout_msg_id
|
The NLS message ID for the provider's
timeout message.
Note: Oracle Portal first attempts to retrieve a timeout message
ID from the portlet, then from the provider. If both attempts fail,
it uses the Oracle Portal default timeout message ID.
Datatype: number
|
|
timeout_msg
|
The message string to be presented when the execution timeout
occurs.
Oracle Portal first attempts to retrieve a timeout message from
the portlet, then from the provider. If both attempts fail, it uses
the Oracle Portal default timeout message.
Note: If the timeout_msg_id is null, this string is added to
the NLS tables and its NLS ID is used as the value for the timeout_msg_id.
Datatype: long
|
|
implementation_style
|
The implementation style used by the
provider. The supported styles are database providers and Web providers.
- Database providers are represented by wwpro_api_provider_registry.
DATABASE_IMPL and wwpro_api_provider_registry. PLSQL_IMPL.
- Web providers are represented by wwpro_api_provider_registry.WEB_IMPL
and wwpro_api_provider_registry.HTTP_IMPL.
Note: A null value is not permitted.
Datatype: number
|
|
implementation_owner
|
The database schema that contains the provider's implementation
packages. This field is only valid for database providers.
Note: A null value is not permitted.
Datatype: varchar2
|
|
implementation_name
|
The name of the provider's implementation package. If the implementation_style
is PLSQL_IMPL, this represents the name of the PL/SQL package that
implements the provider methods.
This field is only valid for database providers.
Note: A null value is not permitted.
Datatype: varchar2
|
|
language
|
The language in which the translatable strings are returned.
Note: A null value is not permitted.
Datatype: varchar2
|
|
enable_distribution
|
A flag that indicates if a provider can be registered on remote
nodes.
Note: An enable_distribution value for providers on remote
nodes is always TRUE.
Datatype: Boolean
|
|
login_frequency
|
Indicates how often Oracle Portal should login with the provider.
For database providers, this flag determines the frequency of calls
made to the do_login API.
For Web providers, this flag determines the frequency of calls
made to initSession.
Notes:
-
If login frequency is wwpro_api_provider_registry.LOGIN_FREQUENCY_ALWAYS,
Oracle Portal performs a login operation every time a portlet,
from this provider, is requested to be viewed.
-
If login frequency is wwpro_api_provider_registry.LOGIN_FREQUENCY_ONCE,
Oracle Portal performs a login operation only the first time
a portlet, from this provider, is requested to be viewed in
the same user session.
-
If login frequency is wwpro_api_provider_registry.LOGIN_FREQUENCY_NEVER,
Oracle Portal does not perform any login with the provider.
-
(Web providers only) If the login frequency is wwpro_api_provider_registry.LOGIN_FREQUENCY_PUBLIC
it indicates that the initSession method is not called. In addition,
no user information is passed to any of the provider calls.
Datatype: varchar2
|
|
http_url
|
The URL Oracle Portal uses to make calls to the Web provider,
as defined during provider registration.
This field is only valid for Web providers, i.e. the implementation_style
is HTTP_IMPL (or WEB_IMPL).
Datatype:varchar2
|
|
same_cookie_domain
|
Indicates whether the Web provider is in the same cookie domain
as Oracle Portal.
Datatype: Boolean
|
|
require_proxy
|
A flag that indicates if a proxy server is required to make a
URL connection.
This field is only valid for Web providers.
Notes:
Datatype: Boolean
|
|
require_session_data
|
A flag that indicates whether session information is to be sent
to the provider.
This field is only valid for Web providers.
Datatype: Boolean
|
|
is_offline
|
A flag that indicates whether the provider is off-line.
Note: A provider must be online during registration. Therefore,
if is_offline is set to 'true' an will error occur.
Datatype: Boolean
|
|
http_app_type
|
A value provided by one of two constants
that indicates if the Web provider being registered requires its
own ID for the user to be communicated to it from the Single Sign-On
Server or the Oracle Portal's ID for the user. Valid http_app_type
values are:
Datatype: varchar2
|
|
http_app_id
|
The ID used to register the external application with the Single
Sign-On Server.
Note: If the http_app_type is EXTERNAL_SECURED, this field
stores the external application ID. Otherwise this field is null.
Datatype: varchar2
|
|
provider_key
|
A key passed to the Web provider. The provider uses it to look
up and track use of the provider's encryption key, and to keep track
of Oracle Portal using their system.
Datatype: varchar2
|
|
encryption_key
|
An encryption key that is shared with the Web provider. This key
is used to encrypt and decrypt data communicated to the provider.
Note: If an encryption key value exists, a provider key value
also must exist.
Datatype: varchar2
|
|
node_name
|
The unique name for the node that the provider belongs to.
Datatype: in varchar2
|
|
dad_name
|
For a provider that exists on a remote node, this is the remote
Oracle Portal's DAD.
Datatype: in varchar2
|
|
db_link
|
A unique name for the database link.
Datatype: in varchar2
|
|
local
|
A flag that indicates if the provider exists on the local node
or on a remote node.
Datatype: Boolean
|
|
accept_registration
|
A flag that indicates if this provider can be registered by remote
nodes.
Note: When a remote node is registered, all providers local
to the remote node that have their Accept Registration flag set
to 1 are registered with the local node as remote providers.
Datatype: Boolean
|
|
http_listener_host
|
For a provider that exists on a remote node, this is the remote
listener's host URL.
Datatype: varchar2
|
|
http_listener_port
|
For a provider that exists on a remote node, this is the remote
listener's host port number.
Datatype: varchar2
|
|
created_on
|
The date that the provider was registered with the Portal installation.
Note: This value is filled in by functions returning a provider_record.
Datatype: date
|
|
created_by
|
The user who registered this provider with the Portal installation.
Note: This value is filled in by functions returning a provider_record.
Datatype: varchar2
|
|
last_updated_on
|
The date this provider was last updated in Oracle Portal.
Note: This value is filled in by functions returning a provider_record.
Datatype: date
|
|
last_updated_by
|
The user who last updated the provider.
Note: This value is filled in by functions returning a provider_record.
Datatype: varchar2
|
|
service_id
|
The service ID for the provider. This uniquely identifies the
provider within a portal when the provider is accessed via the PL/SQL
HTTP Adapter.
Datatype: varchar2
|
|
midtier_proxy_hostname
|
The host name of the proxy to be used for calls to the provider
originating from the middle tier.
Datatype: varchar2
|
|
midtier_proxy_portnumber
|
The port number of the proxy to be used for calls to the provider
originating from the middle tier.
Datatype: number
|
|
dbtier_proxy_hostname
|
The host name of the proxy to be used for calls to the provider
originating from the database.
Datatype: varchar2
|
|
dbtier_proxy_portnumber
|
The port number of the proxy to be used for calls to the provider
originating from the database.
Datatype: number
|
Node provider table:
A table structure containing a list of node_provider_records. A provider_table
structure is returned after calling the provider listing functions. It contains a table of node_provider_record.
type node_provider_rec_table is table of node_provider_record
index by binary_integer;
Global node_provider_record:
Used for caching node provider records.
g_node_provider node_provider_record;
|
