Connecting to Oracle.

[ripu.nanda]

Guys,

Can anyone answer following questions please

1) Do I have to install sqlplus to connect to Oracle database from Perl

2) What , how and where can I get the modules required.

Please treat this as very urgent

Many thanks



Ripu Nanda
Systems Monitoring  Management Tools 
BTNet tel: 00 780 6534 
Tel: 01206 226534 

BTexact Technologies is a trademark of British
Telecommunications plc
Registered office: 81 Newgate Street London EC1A 7AJ
Registered in England no. 180

This electronic message contains information from British
Telecommunications plc which may be privileged or confidential. The
information is intended to be for the use of the individual(s) or entity
named above. If you are not the intended recipient be aware that any
disclosure, copying, distribution or use of the contents of this
information is prohibited. If you have received this electronic message
in error, please notify us by telephone or email (to the numbers or
address above) immediately.

Re: Connecting to Oracle.

[Michael Nhan]

It would help if you could include os type.  But to answer your question
1) no, but it helps when troubleshooting.  Usually if sqlplus works, then 
you know that the client libraries/software and connnectivity is good.

2) depends on the os of choice.


Date: Fri, 7 Jul 2006 

15:50:41 +0100

From: [EMAIL PROTECTED]
To: dbi-users@perl.org
Subject: Connecting to Oracle.

Guys,

Can anyone answer following questions please

1) Do I have to install sqlplus to connect to Oracle database from Perl

2) What , how and where can I get the modules required.

RE: Connecting to Oracle.

[Garrett, Philip \(MAN-Corporate\)]

[EMAIL PROTECTED] wrote:
 Guys,
 
 Can anyone answer following questions please
 
 1) Do I have to install sqlplus to connect to Oracle database from
 Perl 

No, but it typically comes with the files that you DO need (the Oracle
client).  Google oracle instantclient

 2) What , how and where can I get the modules required.

Install DBI and DBD::Oracle from CPAN.  Be sure to read the included
instructions carefully.

Philip

RE: Connecting to Oracle.

[Reidy, Ron]

SQL*Plus is not required to connect from Perl, unless you would like to
run SQL*Plus as a piped process or with expect from within Perl.

You will need to (at a minimum) install an Oracle client on the machine
running the Perl scripts, along with the DBI and DBD::Oracle modules.
The README files that are part of the DBD::Oracle distro have more
informations.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 07, 2006 8:51 AM
To: dbi-users@perl.org
Subject: Connecting to Oracle.

Guys,

Can anyone answer following questions please

1) Do I have to install sqlplus to connect to Oracle database from Perl

2) What , how and where can I get the modules required.

Please treat this as very urgent

Many thanks



Ripu Nanda
Systems Monitoring  Management Tools 
BTNet tel: 00 780 6534 
Tel: 01206 226534 

BTexact Technologies is a trademark of British
Telecommunications plc
Registered office: 81 Newgate Street London EC1A 7AJ
Registered in England no. 180

This electronic message contains information from British
Telecommunications plc which may be privileged or confidential. The
information is intended to be for the use of the individual(s) or entity
named above. If you are not the intended recipient be aware that any
disclosure, copying, distribution or use of the contents of this
information is prohibited. If you have received this electronic message
in error, please notify us by telephone or email (to the numbers or
address above) immediately.



This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.