MOD_PLSQL is an Apache (Web Server) extension module that allows one to create
dynamic web pages from PL/SQL packages and stored procedures.
It is ideal for developing fast and flexible applications that can run on the
Internet or an Intranet.
MOD_PLSQL was formerly called the Oracle PL/SQL Cartridge and OWA (Oracle Web Agent).
For more information about the Apache server, see the Oracle HTTP Server FAQ. More
information about PL/SQL can be obtained from the PL/SQL FAQ.
The Mod_PLSQL Architecture:
+-CLIENT-+ +-----------------S E R V E R---------------+
| | | |
| Web | <--Internet--> | Oracle HTTP <--> mod_plsql <--> Oracle |
| Browser| HTTP | Server Database |
| | | |
+--------+ +-------------------------------------------+
Start a Web Browser like Netscape Navigator and Internet Explorer and navigate
to the MOD_PLSQL Gateway Configuration Menu (http://your.host.name:7777 and click
on "mod_plsql"). Click on "Gateway Database Access Descriptor Settings". Select
one of the options to add a new DAD (Database Access Descriptor). Enter at least
the following fields:
Database Access Descriptor (DAD) Name
Schema Name
Oracle User Name
Oracle Password
Oracle Connect String (if not the local DB)
Click on "Apply" to make your changes permanent.
Configuration parameters and log files are stored in the $ORACLE_HOME/Apache/modplsql
subdirectory.
Standard Oracle PL/SQL programs can be extended to include MOD_PLSQL The Oracle Web Agent extends the Common Gateway Interface (CGI) to Oracle PL/SQL stored procedures.
Programming is done in PL/SQL using the following set of packaged procedures:
HTP - Hypertext Procedures
HTF - Hypertext Functions
OWA_UTIL - Oracle Web Agent Utilities
OWA_COOKIE - Send end retrieve Web Browser Cookies
Etc.
Example PL/SQL procedure:
CREATE OR REPLACE PROCEDURE HelloWorld AS
BEGIN
htp.htitle('My first dynamic Web page');
htp.print('Hello world');
htp.line;
END HelloWorld;
/
To run this example you would typically provide an URL like this to your Web Browser:
Cookies allow any site to store information on a WEB Browser's hard disk (cookie.txt file).
This information is sent back to the originating site whenever you access it again.
