Re: straight forward Oracle unix web solution sought

Oracle's mod_plsql is the Apache module that allows execution of PL/SQL stored procedures. mod_plsql comes with Oracle HTTP Server bundled with 8.1.6 and newer and Oracle9i Application Server.

You should seriously consider using PL/SQL Server Pages (PSP) instead of writing PL/SQL Servlets using the PL/SQL Web Toolkit. Why? Because you can design your pages visually, which isn't possible with PL/SQL Servlets. In case you're interested, you can access my presentation, demos, and white paper on PL/SQL Web application development from OracleWorld 2002 Copenhagen at
http://www.changegroup.biz/en/events_archive.psp?event=OracleWorld2002CPH.

HTH. Finn

"Michael J. Moore" <hicamel_x_the_spam_at_attbi.com> wrote in message news:rK5g9.247246$kp.845660_at_rwcrnsc52.ops.asp.att.net...
> 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 Mon Sep 16 2002 - 19:24:47 CEST