| 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

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