Database provider implementation

Related topics

A database provider is implemented as a PL/SQL package. This package is required to possess a series of special methods in its implementation. The name of the package is flexible since the framework uses the physical implementation name that is specified during provider registration.

To create a provider:

Step 1.

If you intend to store the provider in its own schema, create a schema to hold the provider.

Step 2.

If the provider is implemented in a schema other than that of Oracle Portal, run the provsyns.sql script.

Note: The provsyns.sql file is on your Oracle Portal CD. Instructions for running the script are contained in the file.

Step 3.

Create a package that implements a provider with the following methods:

get_portlet function

get_portlet_list function

get_api_version function

do_login procedure

show_portlet procedure

is_portlet_runnable function

register_portlet procedure

copy_portlet procedure

deregister_portlet procedure

describe_portlet_parameters function

register_provider procedure

deregister_provider procedure

Step 4.

Register the provider with Oracle Portal. To do this, use the Add a Portlet Provider function in the Provider portlet of the Oracle Portal Administer Page.

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