Oracle® MOD_PLSQL PL/SQL Gateway Sample DADs

A DAD using HTTP Basic Authentication

<Location /pls/myapp>
  SetHandler pls_handler
  Order deny,allow
  Allow from all
  AllowOverride None
  PlsqlDatabaseConnectString    orcl
  PlsqlAuthenticationMode       Basic
  PlsqlDefaultPage              scott.home
</Location>

A typical Portal 9.0.2 DAD

<Location /pls/portal>
  SetHandler pls_handler
  Order deny,allow
  Allow from all
  AllowOverride None
  PlsqlDatabaseUsername         portal
  PlsqlDatabasePassword         portal
  PlsqlDatabaseConnectString    host:port:sid
  PlsqlAuthenticationMode       SingleSignOn
  PlsqlDefaultPage              portal.home
  PlsqlDocumentTablename        portal.wwdoc_document
  PlsqlDocumentPath             docs
  PlsqlDocumentProcedure        portal.wwdoc_process.process_download
  PlsqlPathAlias                url
  PlsqlPathAliasProcedure       portal.wwpth_api_alias.process_download
  PlsqlSessionCookieName        portal
</Location>

A typical Login Server instance DAD

<Location /pls/orasso>
  SetHandler pls_handler
  Order deny,allow
  Allow from all
  AllowOverride None
  PlsqlDatabaseUsername         orasso
  PlsqlDatabasePassword         orasso
  PlsqlDatabaseConnectString    host:port:sid
  PlsqlAuthenticationMode       SingleSignOn
  PlsqlDefaultPage              orasso.home
  PlsqlDocumentTablename        orasso.wwdoc_document
  PlsqlDocumentPath             docs
  PlsqlDocumentProcedure        orasso.wwdoc_process.process_download
  PlsqlPathAlias                url
  PlsqlPathAliasProcedure       orasso.wwpth_api_alias.process_download
  PlsqlSessionCookieName        orasso
</Location>

A typical Portal 3.0.x DAD

<Location /pls/portal30>
  SetHandler pls_handler
  Order deny,allow
  Allow from all
  AllowOverride None
  PlsqlDatabaseUsername         portal30
  PlsqlDatabasePassword         portal30
  PlsqlDatabaseConnectString    host:port:sid
  PlsqlAuthenticationMode       SingleSignOn
  PlsqlDefaultPage              portal30.home
  PlsqlDocumentTablename        portal30.wwdoc_document
  PlsqlDocumentPath             docs
  PlsqlDocumentProcedure        portal30.wwdoc_process.process_download
  PlsqlPathAlias                url
  PlsqlPathAliasProcedure       portal30.wwpth_api_alias.process_download
  PlsqlSessionCookieName        portal30
  PlsqlCompatibilityMode        1
</Location>

A typical WebDB 2.x DAD

<Location /pls/webdb>
  SetHandler pls_handler
  Order deny,allow
  Allow from all
  AllowOverride None
  PlsqlDatabaseUsername         webdb
  PlsqlDatabasePassword         webdb
  PlsqlDatabaseConnectString    host:port:sid
  PlsqlDefaultPage              webdb.home
  PlsqlDocumentTablename        webdb.wwv_document
  PlsqlDocumentPath             docs
  PlsqlUploadAsLongRaw          *
  PlsqlDocumentProcedure        webdb.wwv_document.process_download
</Location>