My Oracle Support Banner

How to Migrate Mod_Plsql Applications to ORDS 22.x and Higher (Doc ID 2942072.1)

Last updated on JANUARY 09, 2024

Applies to:

Oracle REST Data Services - Version 22.1 and later
Information in this document applies to any platform.

Goal

The mod_plsql applications were accessed using 'OHS with mod_plsql'.

The following locations are configured in the database access descriptor (DAD) file (dads.conf):

NOTE: The example(s) provided are for demonstration purposes only and represents fictitious sample (based upon made
up data). Any similarity to actual data, web sites and / or persons, living or dead, is purely coincidental and not intended in any manner.

 

For example ->

# ============================================================================
# mod_plsql DAD Configuration File
# ============================================================================

<Location /pls/dev>
SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None
PlsqlDatabaseUsername <devusername>
PlsqlDatabasePassword <password>
PlsqlDatabaseConnectString <host>:<port>:<servicename> ServiceNameFormat
PlsqlAuthenticationMode Basic
PlsqlBeforeProcedure sample_plsql_app_metadata.beforeProc
PlsqlAfterProcedure sample_plsql_app_metadata.afterProc
PlsqlRequestValidationFunction sample_plsql_app_metadata.validationFunc
PlsqlDocumentTablename privileged_user.doc_table
PlsqlDocumentProcedure privileged_user.upload
</Location>


<Location /pls/test>
SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None
PlsqlDatabaseUsername <testusername>
PlsqlDatabasePassword <password>
PlsqlDatabaseConnectString <host>:<port>:<servicename> ServiceNameFormat
PlsqlAuthenticationMode Basic
PlsqlBeforeProcedure sample_plsql_app_metadata.beforeProc
PlsqlAfterProcedure sample_plsql_app_metadata.afterProc
PlsqlRequestValidationFunction sample_plsql_app_metadata.validationFunc
PlsqlDocumentTablename privileged_user.doc_table
PlsqlDocumentProcedure privileged_user.upload
</Location>

 

URLs used to access the mod_plsql applications:

For example ->

http://<host>:<port>/pls/dev/myapp.launch

http://<host>:<port>/pls/test/rockapp.load


 How-To    => How to migrate these mod_plsql applications to ORDS? How to migrate the dads.conf file to ORDS?

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.