Building DBD::Oracle with the new Oracle Express product.

Hi Tim--

I'm having problems building DBD::Oracle with the new Oracle Express
product (see
http://www.oracle.com/technology/products/database/xe/index. html).
This is a new distribution that installs nicely on Linux via a single
RPM.

During the building process I'm getting an error: "Unable to locate an
oracle.mk, proc.mk or other suitable *.mk file in your Oracle
installation. " These files are apparently used for Oracle Pro*C.

Have you come across this problem? Any suggestions?

Thanks,

--Ethan

Re: Building DBD::Oracle with the new Oracle Express product.

On 12/27/05, Ethan Brown wrote:
> Hi Tim--
>
> I'm having problems building DBD::Oracle with the new Oracle Express
> product (see
> http://www.oracle.com/technology/products/database/xe/index. html).
> This is a new distribution that installs nicely on Linux via a single
> RPM.
>
> During the building process I'm getting an error: "Unable to locate an
> oracle.mk, proc.mk or other suitable *.mk file in your Oracle
> installation. " These files are apparently used for Oracle Pro*C.
>
> Have you come across this problem? Any suggestions?
>
> Thanks,
>
> --Ethan
>

Well, it occurred to me that dbi-users@perl.org is actually a mailing
list. I googled and found some postings by you (Tim) about a patch to
Makefile.pl in the thread
http://groups.google.com/group/perl.dbi.users/browse_thread/ thread/f4c50c67=
f7dccfd9/08b3acd637ac2001?q=3Doracle+xe&rnum=3D1#08b3acd637a c2001

I applied the patches, but got an error in the output:
------------------------------
Using Oracle in /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
DEFINE _SQLPLUS_RELEASE =3D "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Looks like Oracle XE
Reading /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/de mo/demo=
_xe.mk
ERROR parsing /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/de m=
o/demo_xe.mk:
Unable to determine what to link with.
---------------------------------

Undaunted, I poked around in Makefile.PL and the file demo_xe.mk, and
figured I could get things to work if I just hard-coded the use of
LIBCLNTSH:
---------------------------------
$linkvia =3D '$(LIBCLNTSH)' if !$linkvia && $MK{LIBCLNTSH};

=09 ## EDB. Force linkvia to use LIBCLNTSH
=09 $linkvia =3D '$(LIBCLNTSH)';
=09 ## END EDB
=09
# The oracle.mk file tends to define OCILDLIBS
$linkvia =3D '$(OCILDLIBS)' if !$linkvia && $MK{OCILDLIBS};
---------------------------------

This ended up doing the trick.

Apologies for not searching more thoroughly before sending my last mail.
(By the way, my platform is Linux Mandrake 10.1 on x86).

Thanks,

--Ethan