Connect ORACLE to WWW through CGI-Perl-Script

From: Ingo Ruth <ingo.ruth_at_stud.uni-erlangen.de>
Date: 1996/12/17
Message-ID: <32B7601B.2D42@stud.uni-erlangen.de>#1/1

Hallo!
I'm trying to connect an ORACLE-DB to the WWW throught CGI. Because I want to learn more about it, I took Perl to write a script - but I don't also want to use oraperl. The database is running on a Solaris2.4 platform, and there is an ORACLE-Web-Server 1.0 for the WWW-requests.

The CGI-Perl-script should do this:

1. Connect DB (here: SQL-PLUS)
2. SELECT * FROM ...
3. DISCONNECT DB

Therefore I wrote this:
[...]

print `sqlplus user/passw`;			
print `select * from obj;`;			
print `exit`;

[...]

As the result in the WebBrowser I could first see something like "connected...", then there was an empty row and at last somthing like "disconnected..." - but no result of the request. I think the problem is about standardin /-out: when the DB is connected, I don't know where <STDIN> and <STDOUT> are lying on.

Next I tried to get the result of the request into a file with the line
print `spool /export/home/www/ergebn.data`; before the select-statement. This should send the answerstream into the file ergebn.data, but I found no file in that path.

At last I put a pipe a) before and b) after the select-statement - nothing new happened.

So what could I do? Is there anybody who knows how to handle standardin/-out in this case?

Ingo Ruth. Received on Tue Dec 17 1996 - 00:00:00 CST