Creating a mod_plsql DAD

If OHS/mod_plsql is part of the Oracle Application Server product, it is recommended that you use Oracle® Enterprise Manager (OEM) to create a DAD. Otherwise, perform the following steps to create a DAD:

1. Edit the DAD configuration file %ORACLE_HOME%/Apache/modplsql/conf/dads.conf

2. Add a DAD where the DAD has the following format:

<Location>
The Oracle HTTP Server <Location> directive which defines a virtual path used to access the PL/SQL Web Application.
This directive begins enclosing a group of directives that apply to the named Location.
For example, the directive <Location /myapp> defines a virtual path called /myapp that will be used to invoke a PL/SQL Web Application through a URL like //host:port/myapp/.
Note: Older versions of mod_plsql were always mounted on a virtual path with a prefix of /pls. This restriction is removed in newer versions but might still be a restriction imposed by some older PL/SQL applications.
SetHandler
The Oracle HTTP Server SetHandler directive which directs Oracle HTTP Server to enable mod_plsql to handle the request for the virtual path defined by the named Location
SetHandler pls_handler
Additional Oracle HTTP Server directives that are allowed in the context of a directive.
Typically, the following directives are used:

Order deny,allow
  Allow from all
  AllowOverride None

One or more mod_plsql specific directives.
For example:

PlsqlDatabaseUsername       scott
PlsqlDatabasePassword       tiger
PlsqlDatabaseConnectString  orcl
PlsqlAuthenticationMode     Basic

Closing </Location>
An Oracle HTTP Server </Location> directive which closes the group of directives for the named Location, and defines a single DAD.

3. Save the edits

4. Obfuscate the DAD password by running the "dadTool.pl" script located in %ORACLE_HOME%/Apache/modplsql/conf. For instructions on performing the obfuscation, please refer to %ORACLE_HOME%/Apache/modplsql/conf/dadTool.README

If OHS/mod_plsql is part of the Oracle Application Server product, then issue %ORACLE_HOME%/dcm/bin/dcmctl updateConfig -ct ohs

5. Restart the Oracle HTTP Server (OHS) for the configuration to take effect.

You can create additional DADs by defining other uniquely named Locations in dads.conf.

Here is an example of a typical PL/SQL application DAD

code><Location /plsqlapp>
  SetHandler pls_handler
  Order deny,allow
  Allow from all
  AllowOverride None
  PlsqlDatabaseUsername         scott
  PlsqlDatabasePassword         tiger
  PlsqlDatabaseConnectString    orcl
  PlsqlAuthenticationMode       Basic
  PlsqlDefaultPage              scott.home
  PlsqlDocumentTablename        scott.wwdoc_document
  PlsqlDocumentPath             docs
  PlsqlDocumentProcedure        scott.wwdoc_process.process_download
</Location>

Some more sample DAD's used by other PL/SQL Web applications are available at: Sample DAD's for mod_plsql