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;`;
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?