Re: Perl Oracle DBD on Ubuntu?

In <egr6js$bmg$1_at_reader1.panix.com> Stan Brown <stanb_at_panix.com> writes:

>In <7s42j2he9u326jta8gog3b19jek8hl5e90_at_4ax.com> Andy Hassall <andy_at_andyh.co.uk> writes:

>>On Sat, 14 Oct 2006 15:42:55 +0000 (UTC), Stan Brown <stanb_at_panix.com> wrote:

>>>I need to get the perl DBD module working on a Ubuntu machine.
>>>
>>>I've installed teh XE database using the Debian package, and I can
>>>connect to the instance with sqlplus. I've installed the Perl DBI
>>>framework via Ubuntus packages. They don't seem to have a package
>>>for the Oracle DBD, so I downloaded that from CPAN.
>>>
>>>However, I can't seem to get it to compile corectly.
>>>
>>>Does the XR package not have enough of Oracle libraries to make this work?
>>>
>>>Can anyone sugest how I can get this working?

>> Perhaps if you posted the errors, and what steps you took to compile it?

>Gladly. thaanks for the fast reply.

>> The XE package contains an Oracle 10.2 client which is sufficient to compile
>>DBD::Oracle as per the instructions in the README file. There's various things
>>you can get wrong, but without seeing what you did and what errors you're
>>getting there's no point just guessing.

>I downloaded the following from CPAN DBD-Oracle-1.18 Installed the perl DBI
>from the Ubuntu packages, set the following environemtn variables:

>ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
>PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin
>TWO_TASK=XE
>LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib

>Did a perl Makefile.PL, which did not look too happy, and trie make, which
>failed miserably. Here's the log of the session:

I got this built.

For the archive. The problem was that I needed to apt-get install build-essentials.

Thanks for the help on this.

Sometimes just knowing it is possibel (with some googling) is enough to get things going!

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin