<div>
Asking the obvious, but do you have Perl DBI and DBD::Oracle installed?<br />
<br />
<a href="http://search.cpan.org/~timb/DBI-1.636/" rel="ugc">http://search.cpan.org/~timb/DBI-1.636/</a><br />
<a href="http://search.cpan.org/~pythian/DBD-Oracle-1.74/" rel="ugc">http://search.cpan.org/~pythian/DBD-Oracle-1.74/</a>
</div>


Asking the obvious, but do you have Perl DBI and DBD::Oracle installed?

http://search.cpan.org/~timb/DBI-1.636/ [http://search.cpan.org/~timb/DBI-1.636/]
http://search.cpan.org/~pythian/DBD-Oracle-1.74/ [http://search.cpan.org/~pythian/DBD-Oracle-1.74/]

<div>
Thanks a lot everytone,<br />
<br />
Below commands solved all of my problem, because I could see what was wrong and then fix it<br />
<br />
use CGI::Carp qw(fatalsToBrowser);<br />
<br />
I have managed to achieve what I wanted.
</div>


Thanks a lot everytone,

Below commands solved all of my problem, because I could see what was wrong and then fix it

use CGI::Carp qw(fatalsToBrowser);

I have managed to achieve what I wanted.

<div>
Hi,<br />
<br />
If the command you used solved your problem then you should select Best Solution as the answer, and any other comments from Experts if they helped you along the way as Assisted Solutions.
</div>


Hi,

If the command you used solved your problem then you should select Best Solution as the answer, and any other comments from Experts if they helped you along the way as Assisted Solutions.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
My requirement is to run CGI/perl on tomcat and connect to oracle database.<br />
<br />
I have managed to run the scripts and have installed few perl module, but cant find a way forward while connecting to oracle database.<br />
<br />
I have a oracle client installed and can connect to database if I run the script from command line (Redhat).<br />
<br />
But the moment I try to run it browser it does not work.<br />
<br />
I am new to perl and not sure how could I see whats wrong with it, I can print all ENV variables which it would need.<br />
<br />
is there a way to capture the errors?<br />
<br />
-AM<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/06_w26/1103418/test-db-cgi1" target="_blank" class="file-inline" title="my perl code (2 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>test-db-cgi1</a>
</div>
</div>


test-db-cgi1

Hi,

My requirement is to run CGI/perl on tomcat and connect to oracle database.

I have managed to run the scripts and have installed few perl module, but cant find a way forward while connecting to oracle database.

I have a oracle client installed and can connect to database if I run the script from command line (Redhat).

But the moment I try to run it browser it does not work.

I am new to perl and not sure how could I see whats wrong with it, I can print all ENV variables which it would need.

is there a way to capture the errors?

-AM

To run CGI/perl on tomcat and connect to oracle database.

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Perl is a high-level, general-purpose, interpreted, dynamic programming languages with over 25 years of development. Perl 5 runs on over 100 platforms from portables to mainframes and is suitable for both rapid prototyping and large-scale development projects.  Perl gained widespread popularity as a Common Gateway Interface (CGI) scripting language, in part due to its regular expression and string parsing abilities. In addition to CGI, Perl is used for graphics programming, system administration, network programming, finance, bioinformatics, and other applications.

Perl

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.