4
Setting up WebDB to run with mod_plsql

This section is for WebDB users who plan to run WebDB version 2.x (2.0, 2.1, 2.2) through mod_plsql.

4.1 Before You Begin

• Use the latest OWA packages shipped with mod_plsql in your WebDB 2.x database. Re-execute owaload.sql with the proper parameters if you are in doubt. Note: This may invalidate some of your existing PL/SQL procedures. You may need to recompile them. See "Installing required packages" for more information

• Set the following in the DAD configuration for the WebDB 2.x schema in wdbsvr.app configuration file.

  Authentication Mode = Basic

  Document Table = schema.wwv_document

  upload_as_long_raw = *

  If you set up your DAD using the Add for WebDB 2.x configuration page (http://<hostname>:<port>/pls/admin_/gateway.htm), these settings will automatically be set.

• To enable WebDB 2.x sites, please connect to the database as the owner of the site and run wwvdocs.sql and wwvdocb.plb. These files are located in the same directory as the owaload.sql and docload.sql files See "Installing required packages" for more information.