14-1. Running a PL/SQL Procedure on the Web
Problem
You'd like to make your PL/SQL procedures accessible to users in a web browser via the Oracle Application Server.
Solution
To run a PL/SQL procedure on the Web, you must first configure a Data Access Descriptor (DAD) within the Oracle Application Server to define the connection information required between mod_plsql
within the Oracle Application Server and the Oracle database that holds the PL/SQL procedures you wish to run. In this example the mod_plsql
configuration file dads.conf
(located in [Oracle_Home]\Apache\ modplsql\conf
) is edited to define the DAD.
<Location /DAD_NAME>
SetHandler pls_handler
Order deny,allow
Deny from all Allow from localhost node1.mycompany.com node2.mycompany.com ...
Get Oracle and PL/SQL Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.