First change to
print "Content-type: text/html\n\n";
then make sure your permissions for the script are right, since win2000 does
have permissions under NTFS file system.
Then you can use trace() at level 2 to see what is going on in your script.
Send the trace output to the list.
Also use CGI::Carp qw(FatalsToBrowser) might help.
Ilya Sterin
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 1:52 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Oracle-DBI-Win2k-Apache
How do we get raw sql "select" output to display in
the browser when connecting to an Oracle DBI script?
Have a test which executes & fine on command line but
same script stops @ connect line when run as cgi
via browser.
Is there something extra required ( to oracle or perl) when transitioning
scripts from command line to authenticating via web?
Using system/manager ( Oracle userid/password) in
the connect string. Print statements, etc work
leading up to DBI connect line then stops (when run
from browser).
TIA!
*******************************************
the test script follows. last working line is the print
statement before connect line. However, same script
runs to completion on NT command line. Not sure
how to debug this since "trace" line never gets reached.
********************************************
#!d:/perl/bin/perl.exe -w
print "Content-type: text/html\r\n\r\n";
use CGI;
BEGIN {
$ENV{SERVER_NAME}="me.company.org";
$ENV{ORACLE_HOME}="c:\orant";
$ENV{ORACLE_SID}="orat1";
$ENV{DBI_TRACE}=3;
$ENV{PERL_DBI_DEBUG}=3;
}
foreach $key (keys %ENV) {
print "$key --> $ENV{$key}";
}
foreach $dir (@INC) {
print "$dir\n"
}
print "\n test11 \n<\H2>";
%attr = (
PrintError => 0,
RaiseError => 1
);
my $dbh = DBI->connect("dbi:Oracle:orat1", "system", "manager", \%attr )
or die "cant connect: , $dbi::errstr(), \n";
$dbh->trace(3, "dbitrace.log");
.
.
********************
