DBMS_EPG – The Embedded PL/SQL Gateway in Oracle 10g Database R2

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.

Cheers

Tim…

Author: Tim...

DBA, Developer, Author, Trainer.

9 thoughts on “DBMS_EPG – The Embedded PL/SQL Gateway in Oracle 10g Database R2”

  1. Jeff: Haven’t you done any PL/SQL web applications?

    I often write internal utility/support websites using mod_plsql because it’s so simple. I guess I should start messing with HTML DB 🙂

    Cheers

    Tim…

  2. Hello tim,
    thank’x for a great article.
    But i have face authentication problem when trying to access the procedure Home from your article. Browser asked for Username and Password for XDB. i have try my XDB username and password but nothing .
    Thx in advance
    dimitra@yandex.ru

  3. Hello, is there a way to prevent the EPG HTTP server to ask database username and password at the first connect with the browser?

    With mod_plsql we could store database credential in the DAD but with EPG this doesn’t seem to be possible.

    Thank you. Kind regards, cris119@operamail.com

  4. Hello, is there a way to prevent the EPG HTTP server to ask database username and password at the first connect with the browser?

    With mod_plsql we could store database credential in the DAD but with EPG this doesn’t seem to be possible.

    Thank you. Kind regards, cris119@operamail.com

  5. Hi all!

    Yes, you can orevent the EPG HTTP server to ask the username and password. For it,you need
    to do this steps:

    1. Create dad with dbms_epg.create_dad
    2. Authorize user to created dad with dbms_epg.authorize_dad
    3. Set database username to created dad with dbms_epg.set_dad_attribute

    For steps 2 and 3, use the same user.

    Regards,
    Rafael

  6. Hi, I’m trying to do an aplication with HTP pages. I configured my dads.conf file but it’s not working.
    So i discovery your article and doit your steps.
    It’s working… but i can run my package.
    How can i configute the dads.conf to run it my package?

    Waiting for an answer … tck you very much

    Att. Marina

Comments are closed.