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

> >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
  Yet another way to do this is to choose your weapons right. I use one of the following approaches:

1. Make a shell-script like:

sqlplus -s usr/passwd << EOF
select * from ...
EOF This can off course be further complicated by introducing PL/SQL. If it turns out to be too complex I use Pro*C to make a small program, which i call from the CGI-shell script.

Regards

Ole Moller Received on Mon Dec 30 1996 - 00:00:00 CST