PL/SQL Web Toolkit

The PL/SQL web toolkit allows you to generate web pages directly from an Oracle8i or Oracle9i database. These pages may be requested by Oracle9iAS or, as in this example, the databases built in webserver. This article assumes the default installation of the HTTP server has taken place and the HTTP server is running.

Database Access Descriptor Configuration
Create PL/SQL Code
Test It

Database Access Descriptor Configuration (DAD)

First we must set up a Database Access Descriptor (DAD) to allow the webserver to connect to the database when a specific URL is requested:

Access the database HTTP server main page via a browser (http://yourServer:7778/).
Click on the "Mod_plsql Configuration Menu" link.
Click on the "Gateway Database Access Descriptor Settings" link.
Click on the "Add Default (blank configuration)" link.
Enter SCOTT as the Database Access Descriptor Name. This will be used in the requesting URL.
Enter the username (SCOTT), password (TIGER) and connect string (W2K1) for the desired database connection.
Select the "Basic" authentication mode.
Click the OK button at the top right of the screen.

The list of DADs will now contain the SCOTT entry, which can be edited if necessary by clicking the edit icon next to it.

Create PL/SQL Code

Next we create the PL/SQL code that will actually produce the web pages. This should be loaded into, or accessable from, the SCOTT schema since this is where the DAD points to:

web_app.sql (Right-click and select "Save Target As...")

Since this code contains fragments of HTML it may look rather odd when displayed by the browser. Either view the source or save the source to a file to read the code.

Test It

Once the DAD is configured and the web_app package is loaded into the SCOTT schema we can test it by opening a browser and requesting the following address, where "yourServer" is the name of the Oracle server:

http://yourServer:7778/pls/SCOTT/web_app.dept_insert_req

Enter some values into the form and press the submit button. The resulting page should show a successful completion message or an error message. In addition the contents of the DEPT table are displayed as an HTML table.

This article has only scratched the surface of the PL/SQL web toolkit. For further informationn see:

Hope this helps. Regards Tim...

Back to the Top.