A
Setting up PL/SQL to run with WebDB

WebDB users running WebDB version 2.x (2.0, 2.1, 2.2) through the PL/SQL Gateway must perform the following steps.

1. Drop any older OWA packages in OWA_PUBLIC or OAS_PUBLIC.

2. Install the latest OWA packages shipped with the PL/SQL Gateway. To do so, connect to the database as the SYS user and at the command prompt run

   @owaload.sql log.txt
   
   

   This may invalidate some of your existing PL/SQL procedures. You may need to recompile them. See "Installing Required Packages" for more information

3. 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

   Extensions to be Uploaded as Long Raw = *

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

4. Connect to the database as the owner of the site and run wwvdocs.sql and wwvdocb.plb to enable WebDB 2.x sites. These files are located in the same directory as the owaload.sql file. See "Installing Required Packages" for more information.