topic Re: DBD-Oracle in Operating System - Linux

DBD-Oracle

Reymond Keiluhu — Mon, 15 May 2006 03:40:00 GMT

Hello All,

I'm quite new to perl-dbd/dbi world. I have installed and run successfully perl DBD-Oracle module. but I'm bit curious about something, which is, you know when we build DBD-Oracle from the source we must set the environment variable for ORACLE_HOME, ORACLE_USERID, ORACLE_SID etc.

my question is, how do we build an DBD-Oracle on one perl instance to connect more than one instance of Oracle? is it possible to do that without installing different perl instance located on different location?
thanks.

Re: DBD-Oracle

H.Merijn Brand (procura — Mon, 15 May 2006 06:01:48 GMT

As long as all the Oracle instances are the same (in respect to Oracle version and bitness), you can use one DBI/DBD script to connect to multiple databases simultaneously

# man DBI

and

# man DBD::Oracle

and then look for the $dbh->connect () calls
There you can define the database to connect to

Enjoy, Have FUN! H.Merijn

Re: DBD-Oracle

Florian Heigl (new acc) — Mon, 15 May 2006 06:31:16 GMT

From what I remember DBD-Oracle will respect the current values of ORACLE_SID et all.

Re: DBD-Oracle

Reymond Keiluhu — Tue, 16 May 2006 01:09:48 GMT

thanks for the response.

does it mean that we cannot utilize one perl instance to connect to different oracle instance located on different machine?

Re: DBD-Oracle

Oviwan — Tue, 16 May 2006 02:10:11 GMT

Hy, of course you can if i understood your question right. look the attachement.

Regards

Re: DBD-Oracle

Reymond Keiluhu — Tue, 16 May 2006 09:40:58 GMT

ok that's answer my question, and the restriction apply as mentioned by Procura.

the next question, if we can specify username & password for each database in the script, why do we need to specify environment variable ORACLE_USERID when we build DBD-Oracle? is that only the default?

Re: DBD-Oracle

H.Merijn Brand (procura — Tue, 16 May 2006 09:46:26 GMT

Yes. It is needed for building and testing.

Those %ENV variables are used to connect () if no specific DBI_DSN is passed.
Exploring deeper functionality of connect () will open a parallel universe :)

Enjoy, Have FUN! H.Merijn

Re: DBD-Oracle

Reymond Keiluhu — Tue, 16 May 2006 09:51:08 GMT

solved. thanks a lot guys.