Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

DBMS_EPG - The Embedded PL/SQL Gateway in Oracle 10g Database Release 2 - Run mod_plsql applications directly from the database using the XML DB HTTP server, rather than Apache.



ronald said...

Great article Tim! Keep up the good work.

Shamim said...

Very Good aricle.
But i can't authorize while trying to make a test. The browser always ask username and password.. i use XDB,SYS pass word but nothing..
P.S. i couldn't register in you site fot these reason add in comment,

Thank'x in advance

Tim... said...

Try dropping the DAD and starting again.

If that doesn't work try dropping it and repeating the process, but this time don't set the "database-username" attribute.

See if that solves your problem.

I've just added a new user to the forum and it worked fine. Make sure you use the correct case for the security word.

If you have ny more trouble with the forum please send m a mail from this page:

http://www.oracle-base.com/misc/SiteInfo.php

Cheers

Tim...

Ben said...

Excellent article, especially considering the dearth of documentation on DBMS_EPG.

I installed Oracle XE for Windows, but I prefer to do manual PL/SQL development rather than use HTML_DB, so Iam trying to set up my own DAD on the embedded PL/SQL Gateway.

So far I've gotten it to work with the following steps:
DBMS_EPG.create_dad('foo','/foo/*');
DBMS_EPG.authorize_dad('foo','FOO'); --(for schema 'FOO')
DBMS_EPG.set_dad_attribute(
'foo',
'authentication-mode',
'Basic');

After this, if I go to http://localhost:8080/foo, it prompts me to log in to the security realm 'XDB'. If I enter the foo schema name and password, I can then access packages in the FOO schema.

Normally, for pl/sql web development I like to use authentication mode CustomOwa. I then implement whatever I want in the OWA_CUSTOM package. But for some reason this isn't working with DBMS_EPG. If I use authentication mode CustomOwa, it still prompts me to login to the realm 'XDB'. But I've coded the realm 'FOO' in my OWA_CUSTOM. I also tried using GlobalOwa and updating the OWA_CUSTOM package in the SYS schema, but that didn't make any difference either. So I'm stuck with using Basic mode for now.

Any ideas? I am going to post this to the Oracle XE Forum once my registration goes through, but I thought I'd ask here as well.

Thanks!

Gopal Misra said...

Oh, very nice article. i m searching 'hor to configure dad in XE', this topic helps me a lot. first time i got prompt for entering username and password... then i remove and create again whti different user... ansd it is working.... thanks, team.

Bill P said...

Thank you! This is some great information.

Can you give me a clue where to find the error log that is equivalent to the Apache/Apache/logs/error.log file? Presumably it's in a database table somewhere.

Egor said...

Thanks, but will the same things work at Oracle 10g?

Tim... said...

The gateway and this package were introduced in the first release of 10g, so yes, it will work.

I qualified it as a 10g R2 article because I've only ever used in 10g R2.

Cheers

Tim...

Small Question said...

Tim,

Useful stuff as usual...

Do you happen to know where the useful bits of info that used to get logged to the Apache error_log and access_log go under EPG?

I can't find any external logs in the file system, or in any of the usual Oracle logs.

I'm hoping they go to a table somewhere and don't get lost.

It's pretty hard to debug a mod_plsql application without them obviously.

?

Tim... said...

Actually, I don't know. All I can see in the manuals is this:

http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14259/xdb22pro.htm#sthref2258

Cheers

Tim...

Alex said...

Tim

You mention updating the listerner.ora file. Won't this be overwritten when AutoConfig is run?

If so, do you of a way around this?

Thanks

Alex

arsamaga said...

Thanks so much for this article. It helped me a lot!

Henrik Wengholt said...

Great article !!

http://nubia.wmoe.dk:8080/my_epg_dad/home

is giving me a blank page

Did I miss some prerequirement ??
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired