Connecting to Oracle.

------_=_NextPart_001_01C6A1D4.B7889EE3
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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=20
BTNet tel: 00 780 6534=20
Tel: 01206 226534=20

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

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.



------_=_NextPart_001_01C6A1D4.B7889EE3--

Re: Connecting to Oracle.

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: ripu.nanda@bt.com
> 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.

ripu.nanda@bt.com wrote:
> Guys,
>=20
> Can anyone answer following questions please
>=20
> 1) Do I have to install sqlplus to connect to Oracle database from
> Perl=20

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.

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: ripu.nanda@bt.com [mailto:ripu.nanda@bt.com]=20
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=20
BTNet tel: 00 780 6534=20
Tel: 01206 226534=20

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

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=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
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.