OWA Replacement Cartridge
Have you ever wanted to.....
Well, then look no further..... You are in luck.
- Use Database Authentication
over the web? (as opposed to storing
usernames and passwords in clear text in a plain OS file). This lets you
log into the database without using the username/password stored in the
owa.cfg file. The username/password you supply on the basic authentication
screen is used to log you in. The DCD information is used only to find the
oracle_home, oracle_sid, connect_string, and error logging directory. The
username and password are ignored.
- Use the
to protect your regular OS files
as well as database data?
(de-authenticate) yourself without exiting the browser and
restarting it. (Useful during development when you want to test many
accounts to see the different reactions each user will get).
- Allow your users to dynamically create their account and then
change their passwords
without having to rewrite a configuration file
or 'bounce' the web listener?
from your client to the file system
directly into long raw column in the database?
from your database to your client?
as they are downloaded either from the file system
or from your database. Powerpoint files are compressed 50% or more, Word
Documents 60% or more...
- Use an
tag to provide an easy way to add a little
bit of dynamic content to your existing static pages?
- Have something equivalent to
Timed statistics to do performance
tuning/tracking for your web applications?
- Have a pre/post subroutine
get invoked before each web agent procedure
call? This allows you to implement your own
authorization scheme in pl/sql, or audit activity, or time certain modules.
- Have all of the above functionality in one integrated Oracle
Web Server cartridge? Or even in a CGI-BIN program (for use with WS 1.x or
2.0.1 to support database authentication).
We have developed a complete web agent replacement that performs all of
the above. It incorporates what used to be CGI-BIN functionality into one
consolidated cartridge and still supports the CGI-BIN.
The CGI-BIN functionality was:
You can get more in depth information on the following topics as well:
We have, for your convienence, compiled binaries for the following platforms:
Oracle Web Agent Image
for downloading blobs from the database
Oracle Web Agent Upload
for uploading blobs into the database and invoking an
existing web agent routine (pl/sql) to further process associated relational
You can always download the source code and compile
it yourself as well.
We have built this against 7.2 as well as 7.3 (it does not need
7.3) but the binaries we have are dynamically linked and depend on the 7.3
libraries being available at runtime on NT.
- Sun Solaris 2.4 and above (statically linked 7.2 binaries, will work
with 7.1 on up. I've tested against 7.1.6, 7.2.3, and 7.3.2)
- Windows NT 3.51 & 4.0 (Oracle 7.3 server binaries only. You need
sqllib18.dll on your system. I've only run this compiled binary against my
local 7.3.2 instance). If you have 7.2 or earlier, you will need to compile
the source code.
Additionally, the binaries where compiled using GCC on Solaris and MS
Visual C/C++ (v 4.0) on NT.