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

Ingo Ruth wrote:
>
> The CGI-Perl-script should do this:
> 1. Connect DB (here: SQL-PLUS)
> 2. SELECT * FROM ...
> 3. DISCONNECT DB
>

i mainly use sybase but it should be no difference. what i usually do is write a shell script to do the database inquiries and then pass the result to perl.

e.g.

$cmd = `/bin/ksh sql.sh arg1 arg2`;
print `$cmd`;

and the in sql.sh you can have

#!/bin/ksh
/sybase/bin/isql -Uuser -Ppasswd << END_SQL your sql goes here
END_SQL
#end of script

hope that helps.

-- 
Charlie Wu
Web Applications Developer/Consultant
AT&T, Atlanta, Georgia