Click here to get back home

DBD::Oracle and various oracle clients

 HomeNewsGroups | Search | About
 comp.lang.perl.modules    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
DBD::Oracle and various oracle clients Stephan Titard 08-01-2006
Posted by Stephan Titard on August 1, 2006, 9:23 am
Please log in for more thread options


I would like to be able to use various DBD::Oracle drivers
one using the client library for oracle 8.1.7.x
and another using the client library for oracle 9.2.x

one (ugly) way would be to build twice DBD::Oracle and then
sistematically change one of the tree to have (say) DBD::Oracle8...

another way would be to subclass in a smart way...
is this doable? anybody maintaining various DBI/Oracle combinations that
could give insight

thanks
--stephan

Posted by Achim Grolms on August 1, 2006, 1:39 pm
Please log in for more thread options


> I would like to be able to use various DBD::Oracle drivers
> one using the client library for oracle 8.1.7.x
> and another using the client library for oracle 9.2.x

Why?

Posted by Stephan Titard on August 2, 2006, 3:06 am
Please log in for more thread options


Achim Grolms escribió:
>> I would like to be able to use various DBD::Oracle drivers
>> one using the client library for oracle 8.1.7.x
>> and another using the client library for oracle 9.2.x
>
> Why?
the same perl tree is used to access different versions of oracle.

sherm's idea in this thread is to have DBD::Oracle and for example
DBDOracle8::DBD::Oracle tweaking PREFIX (or DBD::Oracle8::DBD::Oracle)

thanks
--stephan

Posted by Achim Grolms on August 2, 2006, 9:47 am
Please log in for more thread options


> Achim Grolms escribió:
>>> I would like to be able to use various DBD::Oracle drivers
>>> one using the client library for oracle 8.1.7.x
>>> and another using the client library for oracle 9.2.x
>>
>> Why?
> the same perl tree is used to access different versions of oracle.

Sure. But why?

One idea is to install DBD::Oracle to different PREFIX locations
and use PERL5LIB, ORACLE_HOME and LD_LIBRARY_PATH
to configure the correct locations of Perllibs and
Oracle-code.

Posted by Stephan Titard on August 4, 2006, 8:28 am
Please log in for more thread options


Achim Grolms escribió:
>> Achim Grolms escribió:
>>>> I would like to be able to use various DBD::Oracle drivers
>>>> one using the client library for oracle 8.1.7.x
>>>> and another using the client library for oracle 9.2.x
>>> Why?
>> the same perl tree is used to access different versions of oracle.
>
> Sure. But why?
>
> One idea is to install DBD::Oracle to different PREFIX locations
> and use PERL5LIB, ORACLE_HOME and LD_LIBRARY_PATH
> to configure the correct locations of Perllibs and
> Oracle-code.
Well I try always to minimize the use of env. vars, especially
SHLIB_PATH, LD_LIBRARY_PATH and the such.

On HP-UX (11.0 32bit) I build a distribution with about 350 modules where
all external shared objects are found (modulo one symlink) directly
inside the perl tree
so that it is ready for tar and independent. In the case of a (perl)
built shared library
with external dependency (like DBD/oracle.sl) I create a link to the
external library inside my perl-tree that I use for the install of the
perl module. finally an external OS-dependent command is used to turn
off the use of SHLIB_PATH and the such.

why? "principle of least surprise, probably and KISS too"

I use a couple ugly tricks like to relocate a fresh build
to another place: I build normally for /opt/perl58X (core + modules)
and I "generate" for /var/tmp/p*/perl58X (the core part is actually
installed normally using PREFIX). In all the *sl I reserved enough room
in the shared object header using ///////external/shared/object
which I subsistute directly in the binary.
Does not work yet for solaris, but is mainly ok on cygwin.


hth
--stephan





Similar ThreadsPosted
DBD::Oracle June 15, 2006, 3:22 am
DBD::Oracle on cygwin July 12, 2006, 6:09 am
DBD::Oracle issues January 23, 2007, 7:16 pm
DBI/DBD-Oracle and Proxy June 13, 2007, 11:43 am
Using DBD::pNET with DBD::Oracle August 23, 2007, 8:54 pm
DBI and DBI::Oracle packages configuration July 22, 2004, 8:55 am
Need Help Installing Oracle-DBD on WindowsXP February 6, 2005, 10:30 pm
Install DBD::Oracle crashes November 22, 2006, 3:08 pm
Problem with DBD::Oracle in cgi-script August 28, 2007, 3:15 am
Problem installing DBD-Oracle June 5, 2008, 5:44 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap