Sponsored Content
Top Forums Shell Programming and Scripting How to connect ORACLE using PERL Post 302170952 by Vijayakumarpc on Wednesday 27th of February 2008 06:49:55 AM
Old 02-27-2008
Question How to connect ORACLE using PERL

Hi Friends,

I am having Perl 5 and Oracle 9i. I just wanna to connect Oracle DB & to perform some select query statement.

Could anyone pls let me know.

I've tried below command which i found in some website, But it throws some error.Smilie

Executed:
perl -e 'use DBI; print $DBI::VERSION,"\n";'

Output
Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib /usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1 /usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int /usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at -e line 1.
BEGIN failed--compilation aborted at -e line 1.

and I am not familiar with Perl. When i search for help on Google, I've found some reply like, DBI should be installed. Is this so. or are there any other way instead of using DBI.

Thanks in Advance, Smilie
Vijay,
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

HOw to connect oracle using ksh and perl script

HI, So far i have been worked on sybase with perl and ksh scripts, i don't know how to connect using oralce, if any body could explain that is great. Thanks in advance. chendra (3 Replies)
Discussion started by: chendra.putta
3 Replies

2. Shell Programming and Scripting

How to connect to oracle ??

Hi, I am a new user, who wants to connect to oracle through shell scripting. Can anybody help me? Regards, Divyesh (2 Replies)
Discussion started by: divyesh shah
2 Replies

3. Shell Programming and Scripting

Perl connect to remote oracle db without local oracle installation

I want to use Perl to connect to a remote Oracle DB I have no oracle installation on my server (and dont plan on installing one) I am using solaris 9 on x86 server. Is this possible? I basically want to run some basic sql queries on the remote oracle db which I have access to using perl on my... (0 Replies)
Discussion started by: frustrated1
0 Replies

4. Shell Programming and Scripting

Unix - Oracle DB Connect

Hello, Returing to Unix scripts after a long while, This might be a simple question for most of you , I need to connect from a .sh script to oracle, select XYZ.nextval from dual , , meaning either get the Current Val or Next Val for a sequence. How do I store the return value , I know... (2 Replies)
Discussion started by: Shanks
2 Replies

5. Programming

Help on a perl script to connect to oracle ASM as sysdba

I am novice to perl. Can someone guide me on the below query. We have an existing perl script which connects to database to check the disk group status which i wanted to retieve directly from ASM rather than database. This is because, a cluster has more than 4 databases running and a check on... (0 Replies)
Discussion started by: sai_rsk
0 Replies

6. UNIX for Dummies Questions & Answers

Not able to connect Oracle

In unix i login as root but when i am conneting to SQL as sqlplus "/ as sysdba" then its telling "sh: sqlplus: not found".. (6 Replies)
Discussion started by: ripudaman.singh
6 Replies

7. Shell Programming and Scripting

Switching user to oracle to connect Oracle 11g DB with 'sysdba'

I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'. I've tried the following with no success. su - oracle -c "<< EOF1 sqlplus -s "/ as sysdba" << EOF2 whenever sqlerror exit sql.sqlcode;... (2 Replies)
Discussion started by: NetBear
2 Replies

8. Shell Programming and Scripting

Use perl to connect to Oracle ASM as sysdba

I am novice to perl. Can someone guide me on the below query. We have an existing perl script which connects to database to check the disk group status which i wanted to retieve directly from ASM rather than database. This is because, a cluster has more than 4 databases running and a check on... (1 Reply)
Discussion started by: sai_rsk
1 Replies

9. Shell Programming and Scripting

Connect to Oracle with Perl through Cygwin

I try to connect to Oracle through cygwin, but it fails. The Oracle version 11.2 is installed on a Windows 2003 server. Cygwin and Perl is installed on the same server. cygwin>uname -a CYGWIN_NT-5.2 N0871 1.7.9(0.237/5/3) 2011-03-29 10:10 i686 Cygwin cygwin>perl -v This is perl, v5.10.1... (3 Replies)
Discussion started by: MSiipola
3 Replies

10. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies
INSTALL(3pm)						User Contributed Perl Documentation					      INSTALL(3pm)

NAME
INSTALL Installation instructions for Math::SparseMatrix DEPENDENCIES
This module requires these other modules and libraries: Math::SparseVector SYNOPSIS
To install this module type the following: perl Makefile.PL make make test make install The exact location of where Math::SparseMatrix will be installed depends on your system configuration. If you do not have authority to write into system directories, you can install Math::SparseMatrix in a local directory that you own and have permissions to read and write into as follows: perl Makefile.PL PREFIX=/YOUR/DIR make make test make install This will install the module into /YOUR/DIR/lib/perl5/site_perl/Math/SparseMatrix.pm If you install Math::SparseMatrix in a local directory, you will have to explicitly set your PERL5LIB environment variable to include: /YOUR/DIR/lib/perl5/site_perl if this directory was not already included. Authors Ted Pedersen, University of Minnesota, Duluth. tpederse at d.umn.edu Mahesh Joshi, Carnegie Mellon University maheshj at cmu.edu COPYRIGHT
Copyright (c) 2006-2008, Ted Pedersen and Mahesh Joshi This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to The Free Software Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. perl v5.10.1 2008-03-25 INSTALL(3pm)
All times are GMT -4. The time now is 01:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy