Re: straight forward Oracle unix web solution sought

Doesn't Apache need to have some configuration so that it can find it's way to a PL/SQL procedure?
I don't know how a vanilla Apache server would do that. I used to use OAS with the PL/SQL
cartridge, but I imaging that things have changed since those ancient days. I agree with Daniel thought that using PL/SQL with the HTP and HTF packages is the most straight
forward way to go.
Mike

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3D80AA23.B75BFD36_at_exesolutions.com...
> Mark Bonneville wrote:
>
> > Pardon this newbie to Oracle. We have a competent Oracle DBA in house
> > but his knowledge falls shy of Web Admin. We have an 8.1.7 Oracle
> > instance running on AIX 4.3. I want to connect the instance to the
> > web.
> >
> > I understand Oracle comes with Apache and have a request pending to
> > have it installed and configured on the same server as the Oracle
> > instance. I have worked with Progress, SQL Server and DB2 and set up
> > multiple web sites so I am passingly familiar with web architecture,
> > html, cgi, perl etc. I have set up my own connections between dbs and
> > web server via ksh, perl and cgi. I am hoping for a tighter
> > integration for Oracle.
> >
> > What I need to know is which Oracle solution, toolkit, software
> > topology I should employ to join the Oracle instance and the web
> > server so that I can retrieve the database and server metric data I
> > will store there. Queries will be submitted via html forms and I
> > intend to present the data in line charts (for which I use gnuplot and
> > ppmtogif on my other sites). I usually create web pages in an HTML
> > tool and then add scripting to handle the data presentation.
> >
> > I undertand there is WebDB (for NT and Solaris only?), Oracle Web
> > Server, Oracle Application Server (v9?), PSP, Oracle Web Toolkit, OAS
> > etc etc and all of this over a variety of Oracle versions.
> >
> > Can you point me in the right direction for a basic Oracle DB <--> Web
> > solution?
> >
> > Many Thanks,
> >
> > Mark
>
> If you have no specific needs ... just a connection to the web don't waste
> time with PSP, OAS, Java, etc. Just get the Apache web server running and
> use the built-in HTP and HTF packages. Even 9iAS, as good as it is, is
> there for a specific purpose. If you don't need it don't invest a ton of
> effort in its purchase, installation, configuration, etc.
>
> Daniel Morgan
>
Received on Thu Sep 12 2002 - 21:16:39 CEST