Re: Web access to Oracle.

Isaac Seamantov wrote:
>
> Hi.
>
> I need to know how to access an Oracle server from the Web.
> I'd like to do it from a CGI Perl script.
>
> Where should I start looking ?
>
> Thanks in advance,
> Isaac Seamantov

Isaac: This reply was actually to another message, but it "may" be appropriate to you. At a

        minimum, you may want to check out the books below...

There really isn't any single "right" way to do this. In the large you will need: 1) A Web Daemon

2)  A CGI Tool
3)  A database
4)  Html DOCs

There are many different tools you can use. It sounds like you have 1), 3), & 4) covered. Thus your big decision is which CGI (Common Gateway Interface) Tool to use? I currently am using perl as my CGI. Perl is a pretty decent environment and it is arguably the most popular on the net. There are add-ons to perl as well (oraperl & DBI extensions) which make interacting with an Oracle database even easier...

Other CGI's:
Applescript, C/C++, C Shell, Tcl, Visual Basic, and Oracle's web products...

Assuming you already know Oracle, here is some recommended CGI reading that can help you: CGI Programming on the World Wide Web - O'Reilly & Associates HTML The Definitive Guide - O'Reilly & Associates Learning Perl - O'Reilly & Associates
Programming Perl - O'Reilly & Associates

In closing, please don't assume that I am saying this is the only way to hook Oracle to the Web. There are many tools out there and your toughest work will be deciding which one to use! (I didn't even mention third party tools like BlueStone's Sapphire Web...)

Good Luck!
Scott Unrein

PostScript: No, I don't work for O'Reilly - I love their books!

----------------------My Opinion, Not Exabte's-------------------------------- 
Scott Unrein                            Voice: 303.417.5865
Exabyte Corporation                     Fax:   303.417.7500
1685 38th Street                        email: scottu_at_exabyte.com Boulder, CO  80301