4
Setting up WebDB to run with the PL/SQL Gateway

This section is for WebDB users who plan to run WebDB version 2.x (2.0, 2.1, 2.2) through the PL/SQL Gateway.

4.1 Before You Begin

• Drop any older OWA packages in OWA_PUBLIC or OAS_PUBLIC.

• 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.sqllog.txt
  
  

  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

  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 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 file. See "Installing required packages" for more information.