[Zope] DCOracle Compile Problem

[Andrew Lahser]

Christopher Petrilli wrote:

> > When trying to compile the DCOracle package, I get the error below.
> >
> > I am using Oracle8i, version 8.1.5.0.0. I have checked ORACLE_HOME,
> > LD_LIBRARY_PATH. I can connect with sqlplus.  ProC is installed and
> > configured. I know I am missing something simple, but its going
> > right past me.
>
> Compiling Oracle is not for the faint of heart.  With each release brings
> new library orders and contortions that you have to go through.  We do our
> testing on Solaris (x86 actually) because that's what our paying customer
> runs (the run Sparc, but...).  It would be great to be able to ./configure
> it, but it just doesn't work in practice, so if you don't understand Oracle,
> you're going to have a hard time getting it compiled.  Perhaps we can move
> some of the stuff to more compartmentalized options (more like what _tkinter
> uses).  This is something to think about.
>
> If people can send me the options they used with getting it compiled along
> with;
>
>     * OS and revision
>     * Oracle revision
>     * Incense burned while compiling
>
> I'll be happy to include some information with the distribution.
>
> Chris
>
> --
> | Christopher Petrilli        Python Powered        Digital Creations, Inc.
> | petrilli@digicool.com                             http://www.digicool.com
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://www.zope.org/mailman/listinfo/zope
>
> (To receive general Zope announcements, see:
> http://www.zope.org/mailman/listinfo/zope-announce
>
> For developer-specific issues, zope-dev@zope.org -
> http://www.zope.org/mailman/listinfo/zope-dev )

Ok. This took me several days because I belong in the faint of heart
category. I got Oracle 8.1.5.0.0 to compile on Red Hat 6.0.

I have attached my Setup file below. This is probably overkill, but it
works for me.

Unfortunately, I used a vary rare form of unpronouncable herbal incense.

Setup File

*shared*

# Setup file for Oracle 8.0.4 (Tested for Solarus on Intel and Sparc).
#
# Unfortunately, the libraries needed to link Oracle change from revision
# to revision.
#
# Oracle provides a make file for building "demo" programs in
# $ORACLE_HOME/rdbms/demo/demo_rdbms.mk.  I have been unable to
# use this make file to build Python extensions. Adapting it is
# not adequate, because it may change for new Oracle revs.
# My approach is to use demo_rdbms.mk to build one of the
# demo programs, look at the libraries linked, and start from there. :-(
#

ORACLE_INCLUDES=$(ORACLE_HOME)/rdbms/demo -I$(ORACLE_HOME)/rdbms/public
-I$(ORACLE_HOME)/network/public -I$(ORACLE_HOME)/plsql/public

ORACLE_L=-lnbeq8 -lnhost8 -lnus8 -lldapclnt8 -lnsslb8 -lnoss8 -lnoname8 -lntcp8
-lntcps8 -lnsslb8 -lntcp8 -lntns8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8
-lldapclnt8 -lnsslb8 -lnoss8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8
-lntns8 -ln8 -lnl8 -lclient8 -lvsn8 -lcommon8 -lskgxp8 -lgeneric8 -lmm -lnls8
-lcore8 -lnls8 -lcore8 -lnls8 -lnbeq8 -lnhost8 -lnus8 -lldapclnt8 -lnsslb8
-lnoss8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8 -lntns8 -ln8 -lnl8 -lnro8
-lnbeq8 -lnhost8 -lnus8 -lldapclnt8 -lnsslb8 -lnoss8 -lnoname8 -lntcp8 -lntcps8
-lnsslb8 -lntcp8 -lntns8 -ln8 -lnl8 -lclient8 -lvsn8 -lcommon8 -lskgxp8
-lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8
-lcommon8 -lskgxp8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -ldl -lm
-lpthread -ldl -lm -ldl -lnbeq8 -lnhost8 -lnus8 -lldapclnt8 -lnsslb8 -lnoss8
-lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8 -lntns8 -ln8 -lnl8 -lnro8 -lnbeq8
-lnhost8 -lnus8 -lldapclnt8 -lnsslb8 -lnoss8 -lnoname8 -lntcp8 -lntcps8
-lnsslb8 -lntcp8 -lntns8 -ln8 -lnl8 -lnbeq8 -lnhost8 -lnus8 -lldapclnt8
-lnsslb8 -lnoss8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8 -lntns8 -ln8 -lnl8
-lnro8 -lnbeq8 -lnhost8 -lnus8 -lldapclnt8 -lnsslb8 -lnoss8 -lnoname8 -lntcp8
-lntcps8 -lnsslb8 -lntcp8 -lntns8 -ln8 -lnl8 -lnbeq8 -lnhost8 -lnus8
-lldapclnt8 -lnsslb8 -lnoss8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8
-lntns8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lldapclnt8 -lnsslb8 -lnoss8
-lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8 -lntns8 -ln8 -lnl8 -lnbeq8 -lnhost8
-lnus8 -lldapclnt8 -lnsslb8 -lnoss8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8
-lntns8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lldapclnt8 -lnsslb8 -lnoss8
-lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8 -lntns8 -ln8 -lnl8 -lnbeq8 -lnhost8
-lnus8 -lldapclnt8 -lnsslb8 -lnoss8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8
-lntns8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -lnus8 -lldapclnt8 -lnsslb8 -lnoss8
-lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lntcp8 -lntns8 -ln8 -lnl8 -lsql8 -lsql8

ORACLE_LIBS=$(ORACLE_HOME)/lib/ -L$(ORACLE_HOME)/rdbms/lib
$(ORACLE_HOME)/rdbms/lib/defopt.o $(ORACLE_HOME)/lib/sscoreed.o
$(ORACLE_HOME)/lib/nautab.o $(ORACLE_HOME)/lib/naeet.o
$(ORACLE_HOME)/lib/naect.o $(ORACLE_HOME)/lib/naedhs.o $(ORACLE_L) $(ORACLE_L)

oci_ oci_.c -I$(ORACLE_INCLUDES) -L$(ORACLE_LIBS) -DDCORACLE8

Buffer Buffer.c