Home: Perl Programming Help: Beginner:
How to connect to oracle data base



rammohan
Novice

Feb 27, 2014, 4:17 AM


Views: 2215
How to connect to oracle data base

I'm new to connect to Oracle data base through Perl Script . Please let me know how to connect oracle database through Perl and how select table ? And how to print selected table print to file.. please tell me through example


Laurent_R
Veteran / Moderator

Feb 27, 2014, 4:28 AM


Views: 2213
Re: [rammohan] How to connect to oracle data base

Hi,

you have to use the DBI module (http://search.cpan.org/~timb/DBI-1.631/DBI.pm) and the DBD::Oracle module (http://search.cpan.org/~pythian/DBD-Oracle-1.70/lib/DBD/Oracle.pm). The two links above containt a lot of documentation on how to use them.

The first module is a core module and is thus most probably already installed with your Perl distribution, but the second one might have to be installed.


(This post was edited by Laurent_R on Feb 27, 2014, 5:37 AM)


rammohan
Novice

Feb 27, 2014, 4:41 AM


Views: 2211
Re: [Laurent_R] How to connect to oracle data base

while installing DBD::Oracle module I'm getting error


Code
Warning: No success on command[/usr/bin/perl Makefile.PL INSTALLDIRS=site] 
PYTHIAN/DBD-Oracle-1.70.tar.gz
/usr/bin/perl Makefile.PL INSTALLDIRS=site -- NOT OK
Running make test
Make had some problems, won't test
Running make install
Make had some problems, won't install