in reply to Re^12: CGI-SQL Query Issue
in thread CGI-SQL Query Issue

Hi, What DB, USER & PASSWORD do I need to use? I don't see DB entry in your connect string. Anyways, I adapted USER & PASSWORD info & it threw HTTP 500 error. Regards

Replies are listed 'Best First'.
Re^14: CGI-SQL Query Issue
by poj (Abbot) on Mar 18, 2016 at 18:31 UTC

    Try the same username/password/sid as your SQLplus connection.
    Run this to compare the web and command line environments

    #!/usr/bin/perl
use strict;
use warnings;
use Data::Dumper;
print "Content-type: text/plain\n\n";
print Dumper \%ENV;

    [download]
    poj
[reply]
[d/l]
      Hi, Can you please tell about this SID? It seems it is not configured in my system. When I do a print of $ORACLE_SID, it does not print anything..
[reply]

        See connect, if ECSP is a service name then try that.

[reply]
[reply]

In Section Seekers of Perl Wisdom