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");
.
.
********************
