This content has been marked as final. Show 4 replies
For one, you can run OHS/Apache against 11g. There is nothing to stop you from doing that.1 person found this helpful
However, I am not sure how you are using the packages in OHS. Are you referring to calling procedure through URL?
If yes, then you can do the same using ApexListener as well; exactly the way you did with OHS.
a) You have use /apex/proc_name=.. syntax
b) You have to allow access the procedure /function in ApexListener Security section.
Just to make the picture complete: You can see each APEX Listener instance as one DAD, as each can be configured to connect to a certain schema. For APEX, this will usually be APEX_PUBLIC_USER, but you can configure any database user you want. If you want both APEX and some custom DAD, you have to create a second APEX Listener instance. Depending on the JEE Container you use, this could be done by deploying the APEX Listener twice, e.g. first to context "/apex" (the default scenario) and second to your PLSQL-context (e.g. "/plsql").1 person found this helpful
I would add that if your application expects database authentication - i.e. your DAD has Authentication set to Basic, and does not have a fixed username and password, you will not be able to use the ApEx listener without making a few changes to your application. You'll need to add your own authentication pages and methods, and expect that users will all connect as a shared proxy account. The other authentication modes are possible, but are not configured the way they are in a DAD and you may still have to make a few changes to your application.1 person found this helpful
The packages are called directly via URL. i.e.: http://servername/pls/dadname/package.proc
Security is handled via the DAD setup, authentication set to "basic". Some entries use a "generic" userid/password, others require the user to provide credentials.
Looks like I need to get to know APEX a little better.
Thanks for the replies. I'll have to do some research and testing before I mark this as answered.
If I have any more questions, I'll be back. Meanwhile, you've all been helpful. Thanks again!
Edited by: acrsny on May 7, 2012 12:04 PM