Solved

Integration of Perl and Apache and Oracle on Win NT

Posted on 2003-11-18
2
246 Views
Last Modified: 2010-03-04
Hello
Im a new programmer to Perl and I 'm stuck with the connection of Perl with Apache and Oracle on Win NT platform
I would greatly appriciate any help
Thanks in adavance
Amit
0
Comment
Question by:ronan_40060
2 Comments
 
LVL 2

Accepted Solution

by:
Itatsumaki earned 50 total points
ID: 9774363
Did you install DBI and DBD::Oracle to facilitate interaction with Oracle?  You need those two modules to access the ddatabase.  You would then use code like this:

use DBI;
my $dbh = DBI->connect('dbi:Oracle:db_name', 'SCOTT', 'TIGER');
my $sql = 'SELECT COUNT(*) FROM ALL_TABLES';
my $sth = $dbh->prepare($sql);
$sth->execute();

while (my $row = $sth->fetchrow_array()) {
    print $row, "\n";
   }

As for the Apache integration, did you set up mod_perl?  Just as a simple test on CGI server, you can load a redirect page in cgi-bin/test.pl and access that from your browser.

use CGI;
my $cgi = new CGI;
print $cgi->redirect('http://www.google.com');

And presto, you have integrated and connected everything!
0
 
LVL 20

Expert Comment

by:jmcg
ID: 10093369
Nothing has happened on this question in more than 7 weeks. It's time for cleanup!

My recommendation, which I will post in the Cleanup topic area, is to
accept answer by Itatsumaki.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jmcg
EE Cleanup Volunteer
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Email validation in proper way is  very important validation required in any web pages. This code is self explainable except that Regular Expression which I used for pattern matching. I originally published as a thread on my website : http://www…
I have been pestered over the years to produce and distribute regular data extracts, and often the request have explicitly requested the data be emailed as an Excel attachement; specifically Excel, as it appears: CSV files confuse (no Red or Green h…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question