Description of the illustration imurg001b.png

This is a text description of imurg001b.

The main components of a PL/SQL Web application consist of Oracle HTTP Server, Oracle Database, and a Web browser.

Oracle HTTP Server contains the mod_plsql plug-in (one implementation of the PL/SQL Gateway), the database access description (DAD) that contains the database connection information, and the file system where static HTML files and images are stored for use by Web applications.

Oracle Database contains the PL/SQL stored procedures of the Web application and the PL/SQL Web Toolkit. The PL/SQL stored procedures are used to upload, retrieve, and optionally process multimedia data stored in Oracle Database. The PL/SQL Web Toolkit contains a set of packages, including htp, htf, and owa. These packages are used in the stored procedures to get information about the Web application request, construct HTML tags, and return header information to the client Web browser as the response returned to PL/SQL Gateway. From the PL/SQL Gateway, the response is returned to the HTTP server for hosting as a formatted Web page for the client Web browser.