undefined reference to `sqlcxt' (Pro C compilation problem)

[ferdous]

Hi
Greetings to all
I am new to ProC. I am compiling a very simple program written in
ProC. I can compile the program using proc filename.pc and it
generates the corresponding c code :) , but when i try to compile the
C program using

cc -O3 -DPRECOMP -I. -I/opt/oracle/products/9.2.0/rdbms/public
-I/opt/oracle/products/9.2.0/precomp/public
-I/opt/oracle/products/9.2.0/rdbms/demo
-I/opt/oracle/products/9.2.0/plsql/public
-I/opt/oracle/products/9.2.0/network/public -DLINUX -D_GNU_SOURCE
-D_GNU_SOURCE -DSLTS_ENABLE -DSLMXMX_ENABLE -D_REENTRANT -DNS_THREADS
-L /opt/oracle/products/9.2.0/precomp/lib/ -L
/opt/oracle/products/9.2.0/lib/ -L
/opt/oracle/products/9.2.0/lib/stubs/ filename.c -ldl -lm -lpthread
-lnsl -o filename

the result is an error reporting LIKE THIS

filename.c: In function `main':
filename.c:152: warning: return type of `main' is not `int'
/tmp/ccoa0TeD.o: In function `main':
/tmp/ccoa0TeD.o(.text+0x143): undefined reference to `sqlcxt'
/tmp/ccoa0TeD.o(.text+0x2e9): undefined reference to `sqlcxt'
collect2: ld returned 1 exit status

I also tried using
make -f /opt/oracle/products/9.2.0/precomp/demo/proc/demo_proc.mk
filename, but here also unfortunately same situation.

Can any one have any idea what can be done??? Thanx in advance.
Ferdous

[Lothar]

Hi Ferdous,

i assume, your´e compiling on Unix/Linux.
sqlcxt is an external variable defined in libclntsh.so.
Just compile with "-L $(ORACLE_HOME)/lib -l clntsh" and it should
work.

libclntsh.so itself is created at install time by the shell script
$ORACLE_HOME/bin/genclntsh.

Regs, Lothar

[jd_hsu]

Explicitely give the library name in the command line

gcc $ORACLE_HOME/lib/libclntsh.so [...] filename.c