Click here to get back home

DBD::Oracle and various oracle clients
 Home | NewsGroups | Search | About
Login Password
Register Now! Lost Password?
 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
Get Chitika Premium
Posted by Stephan Titard on August 4, 2006, 8:56 am
Please log in for more thread options


> 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"
>

actually, Nicholas Clark has been doing lately work on the relocation
problem
of a core distribution (see p5p about 2 months ago)
it is not easy and the double dependency problem is not handled
completely (as far as I can tell for HP-UX and external modules)

Posted by Sherm Pendley on August 1, 2006, 4:27 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

Easy - just use the PREFIX or LIB options to "perl Makefile.PL" to install
them in different locations. Then "use lib" in your script to add one or
the other location to Perl's module search path.

Have a look at "perldoc perlmodinstall" for details.

sherm--

--
Web Hosting by West Virginians, for West Virginians: http://wv-www.net
Cocoa programming in Perl: http://camelbones.sourceforge.net

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


Sherm Pendley 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
>
> Easy - just use the PREFIX or LIB options to "perl Makefile.PL" to install
> them in different locations. Then "use lib" in your script to add one or
> the other location to Perl's module search path.
>
> Have a look at "perldoc perlmodinstall" for details.
>
> sherm--
>
Yes, but this implies having e.g DBDOracle8::DBD::Oracle or even
DBD::Oracle8::DBD::Oracle, a bit ugly...
it has implications with respect to the automatic discovery of drivers
by DBI (dbi:Oracle:host -> dbi:Oracle8174:host etc...)

I would have liked DBD::OracleXXX
maybe I could make DBD::Oracle8 a proxy for DBDOracle8::DBD::Oracle
I have to look into that (maybe use some of the tricks of the 'aliased'
module)
almost seems safer to transform the code.

thanks
--stephan

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



> Yes, but this implies having e.g DBDOracle8::DBD::Oracle or even
> DBD::Oracle8::DBD::Oracle, a bit ugly...
> it has implications with respect to the automatic discovery of drivers
> by DBI (dbi:Oracle:host -> dbi:Oracle8174:host etc...)
>
> I would have liked DBD::OracleXXX
> maybe I could make DBD::Oracle8 a proxy for DBDOracle8::DBD::Oracle
> I have to look into that (maybe use some of the tricks of the 'aliased'
> module)
> almost seems safer to transform the code.
>
> thanks
> --stephan
actually this is a generic question how to have A::B install as A1::B1
(not <PREFIX>A::B)
or make A::B completely equivalent to MY::A::B (this must work for
procedural o OO interface)

hth
--stephan


Posted by Sherm Pendley on August 2, 2006, 10:49 am
Please log in for more thread options



> Sherm Pendley 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
>>
>> Easy - just use the PREFIX or LIB options to "perl Makefile.PL" to install
>> them in different locations. Then "use lib" in your script to add one or
>> the other location to Perl's module search path.
>>
>> Have a look at "perldoc perlmodinstall" for details.
>>
>> sherm--
>>
> Yes, but this implies having e.g DBDOracle8::DBD::Oracle or even
> DBD::Oracle8::DBD::Oracle

No, it doesn't.

> it has implications with respect to the automatic discovery of drivers
> by DBI (dbi:Oracle:host -> dbi:Oracle8174:host etc...)

No, it doesn't.

Please - read "perldoc perlmodinstall" to see what PREFIX and LIB *really*
do before making further incorrect assumptions.

sherm--

--
Web Hosting by West Virginians, for West Virginians: http://wv-www.net
Cocoa programming in Perl: http://camelbones.sourceforge.net

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