Re: Connect ORACLE to WWW through CGI-Perl-Script

In <32B7601B.2D42_at_stud.uni-erlangen.de> Ingo Ruth <ingo.ruth_at_stud.uni-erlangen.de> writes:

>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.

I've been doing some of this lately. Put your SQL in a file and run by:

system("sqlplus user/passw @sql_name.sql 2>&1 >/dev/null");

The "@" is important for oracle to find the sql. Spool your output to a file, then open in perl. Remember to put a "spool off" after the select-statement.

Have fun,
Patrick Received on Tue Dec 17 1996 - 00:00:00 CST