undefined reference to `sqlca'
I am getting an undefined reference to sqlca in my application. Our code is doing a "EXEC SQL include sqlca;"
statement to use the Oracle sqlca structure. I am using the oracle make files in my application. I also tried to compile the /usr/oracle/app/oracle/product/9.2.0.4/plsql/demo/demo_plsql.mk
demo applications and I am getting the same error.
The Linux version is:
"Red Hat Enterprise Linux ES release 3 (Taroon Update 3)
Kernel 2.4.21-20.EL on an i686"
make -f demoplsql.mk sample6
make[1]: Entering directory `/usr/oracle/app/oracle/product/9.2.0.4/plsql/demo'
/usr/bin/gcc -O3 -DLINUX -D_GNU_SOURCE -D_LARGEFILE64_SOURCE=1 -D_LARGEFILE_SOURCE=1 -DSLTS_ENABLE -DSLMXMX_ENABLE -D_REENTRANT -DNS_THREADS -o sample6 sample6.o -L/usr/oracle/app/oracle/product/9.2.0.4/lib/ -lsql9 -lclntsh `cat /usr/oracle/app/oracle/product/9.2.0.4/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 `cat /usr/oracle/app/oracle/product/9.2.0.4/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lclient9 -lvsn9 -lwtc9 -lcommon9 -lgeneric9 -lwtc9 -lmm -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 `cat /usr/oracle/app/oracle/product/9.2.0.4/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 `cat /usr/oracle/app/oracle/product/9.2.0.4/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lclient9 -lvsn9 -lwtc9 -lcommon9 -lgeneric9 -ltrace9 -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 -lclient9 -lvsn9 -lwtc9 -lcommon9 -lgeneric9 -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 `cat /usr/oracle/app/oracle/product/9.2.0.4/lib/sysliblist` -ldl -lm
sample6.o(.text+0x87): In function `main':
: undefined reference to `sqlca'
sample6.o(.text+0x1cd): In function `main':
: undefined reference to `sqlca'
sample6.o(.text+0x2dc): In function `main':
: undefined reference to `sqlca'
sample6.o(.text+0x5a0): In function `main':
: undefined reference to `sqlca'
sample6.o(.text+0x62c): In function `main':
: undefined reference to `sqlca'
sample6.o(.text+0x64a): more undefined references to `sqlca' follow
collect2: ld returned 1 exit status
make[1]: *** [build] Error 1
make[1]: Leaving directory `/usr/oracle/app/oracle/product/9.2.0.4/plsql/demo'
make: *** [sample6] Error 2
Can anybody help? This has me stubbed. I have checked my Libraries paths.
I have noticed one thing. There is a sqlca.h in /usr/include. This should not effect the Oracle makes (I hope).
Thank-you
Dennis Russell