in reply to Re^5: Error running CGI on tomcat
in thread Error running CGI on tomcat

Can you please help me locate the sqlnet.log file? Is it the one under the deafult C:\Documents and Settings\<user> folder? Also, I just found out that the Oracle DB connectivity code works fine as a PL file from the command line using perl.exe. It is only through a CGI script (web) that it is failing. I am not sure, but may be the code cannot read ORACLE_HOME in the CGI, running on tomcat! Any ideas on how I can make the Windows Environment Variables visible to the CGI script?

Replies are listed 'Best First'.
Re^7: Error running CGI on tomcat
by rdfield (Priest) on Sep 14, 2007 at 08:21 UTC
    You could check the environment in both scripts: 
    foreach my $key (%ENV) {
   print "$key => $ENV{$key};
}

    [download]
    and make sure that they are the same. You might also want to check @INC too: your tomcat installation might be pointing to a different perl (& libraries) than your command line.

    rdfield

[reply]
[d/l]

In Section Seekers of Perl Wisdom