I’ve been playing around with the DBMS_EPG package in Oracle 10g Database Release 2. This allows you to configure Database Access Descriptors (DADs) to run mod_plsql applications directly from the database without using an application server or the HTTP server from the companion CD. Instead it uses the XML DB HTTP server. I’ve written an article on it on my website:
DBMS_EPG – The Embedded PL/SQL Gateway in Oracle 10g Database R2
It definitely works, but I’ve tried it on both RHEL4 and Windows and it feels a little dodgy. I think I’ve already found one bug, mentioned in the article, but it might just be me doing something wrong. I’m not sure if it’s ready for a production application, but it’s certainly a nice idea.