What is the PL/SQL Gateway?

Related topics

The mod_plsql Gateway provides support for building and deploying PL/SQL-based applications on the Web. PL/SQL stored procedures can retrieve data from database tables and generate HTTP responses containing formatted data and HTML code to display in a Web browser. mod_plsql supports other Oracle products such as WebDB 2.X.

 What are Data Access Descriptors (DADs)?

A DAD is a set of configuration values that specify how the PL/SQL gateway connects to the Oracle database server to fulfill an HTTP request.

Each mod_plsql request is associated with a database access descriptor (DAD), a named set of configuration values used for database access. A DAD specifies information such as:

  • the database alias (SQL*Net V2 service name).

  • a connect string if the database is remote.

  • a procedure for uploading and downloading documents.

You can also specify a username and password information in a DAD; if they are not specified, the user will be prompted to enter a username and password when the URL is invoked.

There are separate DADs for:

  • Each instance of Oracle Portal. An instance is a single installation of Oracle Portal. Instances are also referred to as nodes.

  • The Login Server if this has been installed.

Related topics

Configuring the PL/SQL Gateway