Subject: Re: Compiling oraperl with Oracle 7.
Newsgroups: comp.lang.perl

In article <[email-masked]> [email-masked] (David Jablonski) writes:
>
>Hello,
>
>	I am having problems compiling oraperl with Oracle version
>7.0.13.  The linker can not seem to resolve some of the symbols within
>the oracle libraries.  In particular the linker reports:
> 
>Undefined                       first referenced
> symbol                             in file
>btoi                               /oracle/7.0.13/lib/libora.a(kpuscn.o)
>osnqrn                             /oracle/7.0.13/lib/libora.a(osncon.o)
>osnqig1                            /oracle/7.0.13/lib/libora.a(osncon.o)
> 
>	Has anyone out there seen these problems or otherwise been able
>to get oraperl and this version of oracle to link successfully?  Please
>reply to "[email-masked]".  I appreciate any help you can give. 
>Thanks.
> 

This worked for me: (note the order of the libs and sqlnet appearing twice!)

===CUT===
Change these Makefile lines:
< OCILIB    = $(ORACLE_HOME)/rdbms/lib/libocic.a
< NETLIBS   = $(ORACLE_HOME)/rdbms/lib/osntab.o \
<             $(ORACLE_HOME)/rdbms/lib/libsqlnet.a 
< ORALIBS   = $(ORACLE_HOME)/rdbms/lib/libora.a
< ALL_ORA_LIBS = $(CLIBS) $(OCILIB) $(NETLIBS) $(ORALIBS)
---
to these:
> OCILIB    = -locic
> NETLIBS   = $(ORACLE_HOME)/lib/osntab.o -lsqlnet
> ORALIBS   = -lora -lcv6 -lcore -lsqlnet
> ALL_ORA_LIBS = -L$(ORACLE_HOME)/lib $(CLIBS) $(OCILIB) $(NETLIBS) $(ORALIBS)
===CUT===

>                                        --David
>
Regards,
Tim Bunce