Hi all,
I'm newbie using Oracle and i'm just trying to connect it on my Web page.i ' ve
been looking for answers in the mailing list however i'm stuck right now.The code
below is the code i'm trying to do that and the problem is that is not connecting ,
its not showing any error message and the message Hello world that i put is not be
showed on my web browser. I think the process is killed after "use DBD::Oracle
qw(:ora_types); " i don't know why. I have Win2K and Oracle 8i personal edition in my
computer. I hope someone can help me....i want to learn that.
Tks in advance
Fabio (Brazil)
use CGI qw/:standard :html3 -no_debug/;
$query = new CGI;
print $query->header();
use DBI;
use DBD::Oracle qw(:ora_types);
my $dbh = DBI->connect('dbi:Oracle:Oracle','system','manager')
or die "Couldn't connect to database: " . DBI->errstr;
my $sth = $dbh->prepare( qq{select sysdate from dual} )
or die "Couldn't prepare statement: " . $dbh->errstr;
print "Hello World\n";
$sth->finish;
$dbh->disconnect;
exit;
