comment on

The below is a piece of code what we have in the environment

#!/usr/bin/perl
use DBI;
use Date::Manip;
#use String::Substrings;
use Fcntl; #The Module


$ENV{'ORACLE_HOME'}="/u01/app/oracle/product/10.2.0/client_1";
$ENV{'LD_LIBRARY_PATH'}="/u01/app/oracle/product/10.2.0/client_1/lib";
print "content-type: text/html \n\n";
print "<font face=verdana size=3><b>Netcool : Historical Report Versio
+n 2.0</b></font><hr size=1 noshade color=white>";
##-----------database connection ####################
$dbh = DBI->connect('dbi:Oracle:orcl','username','password', { RaiseEr
+ror => 1, AutoCommit => 0 }) or die "\n----------Unable for connect t
+o server $DBI::errstr\n";
[download]

I am using https protocol for accessing the url https://servername.com:16316/ibm/console/webtop/cgi-bin/oracle_reporter2.cgi. Please suggest any modification to be done.

20100706 Janitored by Corion: Added formatting, code tags, as per Writeup Formatting Tips

In reply to Re^4: Connecting to Oracle DB using DBI from CGI script by Anonymous Monk
in thread Connecting to Oracle DB using DBI from CGI script by Anonymous Monk

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


laziness, impatience, and hubris
	PerlMonks