Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.misc -> Re: Application architecture advices needed

Re: Application architecture advices needed

From: Antoine D. <>
Date: Fri, 19 Nov 2004 00:01:40 GMT
Message-ID: <EJand.15568$>

Well, first thanks for your answer. I understand that these packages are exactly what I need for the second half of my application (and actually small tests I have done are ok !!!)

Now, I would like to know which is the best architecture for Oracle to be able to terminate HTTP requests. I guess Apache is involved (probably with some modules mod_header or whatever).
But is it possible to use the Oracle listener for example ?

HTTP Client ---------> (Apache ?) - Oracle ----------------> Web server

HTTP Client is doing requests with a cutom HTTP header. (Apache ?)-Oracle should process the request, get the custom header value,
do an SQL query to its database with the header value as a parameter, from the one of the SQL query result fields, get new URLs, and then POST to these URLs.

"DA Morgan" <> a écrit dans le message de news: 1100758616.751673_at_yasure...
> Antoine D. wrote:
>> Hi,
>> I am skilled in Unix but pretty new to Oracle. I have to build an Oracle
>> database that can be queried with variable URLs. From some documentations
>> I have already read, I believe I need Apache as a frontend with CGI
>> scripts, Perl or whatever to get variable part from URL. Then, I can send
>> a request to Oracle and get back some data to my script.
>> But more over, from these data, I need to construct and send few HTTP
>> requests (actually POSTs) to another server. I was thinking I could use
>> the Perl LWP:UserAgent module for example.
>> But, I am not sure at all about products and/or langages (except Oracle
>> that is a requirement) is the best choice to build and develop my
>> application server. Is there some software architect around that can give
>> me advices ?
>> (For information, all stuff (Oracle, Apache and scripts) must reside on
>> an unique Solaris based server.)
>> Regards
>> Antoine
> From your post I am not sure what it is you are trying to do ... but check
> out the following:
> Go to
> click on Morgan's Library
> click on UTL_INADDR
> also click on UTL_URL
> These may help
> --
> Daniel A. Morgan
> University of Washington
> (replace 'x' with 'u' to respond)
Received on Thu Nov 18 2004 - 18:01:40 CST

Original text of this message