Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> apache and mod_plsql (was RE: Plain old database)

apache and mod_plsql (was RE: Plain old database)

From: Sarnowski, Chris <csarnows_at_CuraGen.com>
Date: Fri, 14 Feb 2003 09:09:44 -0800
Message-ID: <F001.0054DDB1.20030214090944@fatcity.com>

One ought to be able to. We haven't tried, since we've been using mod_owa www.sharemation.com/~dmcmahon/modowa.htm , for historical reasons. Since it is working well for us we haven't tried to replace it with mod_plsql.

One reason we went with our own Apache build was because Oracle's version of Apache was very old. I haven't looked into it recently: maybe they've gotten better.

mod_owa (and mod_plsql) opens a database connection, sets up the bind variables and environment variables, and invokes the plsql package in a begin/end block. It then collects the output from htp.p etc calls and presents the output back to the browser. This is an over-simplified overview.

-Chris

-----Original Message-----

Sent: Friday, February 14, 2003 5:14 AM
To: Multiple recipients of list ORACLE-L

Hi Steve

mod_plsql is pretty much a module that allows you to setup communication between Oracle db and Apache process in a cgi-like way. I have to admin that I don't know exactly, if the pl/sql engine runs embedded within apache like mod_perl for instance. But I don't think so, since I guess it has to run within the context of the database process. By the way, does anybody know if it's possible to compile a "real" apache form apache.org with mod_plsql and dismiss the one oracle delivers ?

LEGAL NOTICE:
Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Sarnowski, Chris
  INET: csarnows_at_CuraGen.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Feb 14 2003 - 11:09:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US