cgi gateway to oracle database

From: <hchen42j15_at_my-dejanews.com>
Date: Mon, 19 Apr 1999 22:11:15 GMT
Message-ID: <7fg9lr$50d$1@nnrp1.dejanews.com>

I had following problem when I tried to use DBI/DBD (DBI version 1.06, DBD version 0.60) to connect to Oracle database (version 7.3.4). The following script runs ok under Unix environment but fails when accessing through Web. It seems that the ora_login function fails. I appreciate if anyone can help me out.

H. Chen

---

#!/opt/pub/exptools/bin/perl

use Oraperl;

print "Content-type: text/plain", "\n\n";

$lda = &ora_login ($system_id, "scott", "tiger");
# $system_id is the connecting string for the database

$csr = &ora_open ($lda, " select sysdate from dual ");
($sdate) = &ora_fetch ($csr);
&ora_close ($csr);
&ora_logoff ($lda);
print "today is $sdate", "\n";

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Apr 19 1999 - 17:11:15 CDT