Re: URGENT: Running external procedure compiled using Oracle 8.1.7 libraries from 9i

From: Kari Pannila <fikkari_at_ougf.fi>
Date: Sat, 15 Feb 2003 11:26:36 +0100
Message-ID: <b2l4km$gj4$1@news.brutele.be>

Hi

You must compile/relink the library

I used in my tests make file from demos
($ORACLE_HOME/rdbms/demo/demo_rdbms.mk).

Example ( HP-UX 11.11 ):
I have palaute.c file which I want to compile:

make -f demo_rdbms.mk extproc_callback SHARED_LIBNAME=palaute.so OBJS=palaute.o

Output is:

cc +DA2.0W
+DS2.0 -DSS_64BIT_SERVER -I/opt/oracle/app/oracle/product/9.2.0/rdbms/demo - I/opt/oracle/app/oracle/product/9.2.0/rdbms/public -I/opt/oracle/app/oracle/

product/9.2.0/plsql/public -I/opt/oracle/app/oracle/product/9.2.0/network/pu
blic     -c -I/opt/oracle/app/oracle/product/9.2.0/rdbms/demo -I/opt/oracle/
app/oracle/product/9.2.0/rdbms/public -I/opt/oracle/app/oracle/product/9.2.0

/plsql/public -I/opt/oracle/app/oracle/product/9.2.0/network/public -I/opt/o racle/app/oracle/product/9.2.0/precomp/public palaute.c

        ld -G

/opt/oracle/app/oracle/product/9.2.0/lib/libclntsh.sl -b -L/opt/oracle/app/o
racle/product/9.2.0/lib -L/opt/oracle/app/oracle/product/9.2.0/lib/ -L/opt/o
racle/app/oracle/product/9.2.0/rdbms/lib/ -o palaute.so palaute.o
/opt/oracle/app/oracle/product/9.2.0/lib/libpls9.a -lclntsh   `cat
/opt/oracle/app/oracle/product/9.2.0/lib/sysliblist`  -lm

And result files:

-rw-------    1 pan    users         2944 Feb 15 11:18 palaute.o
-rwx--x--x   1 pan    users         6072 Feb 15 11:18 palaute.so

Regards Kari

"Ashish" <ashish_tiwari_at_infosys.com> wrote in message news:d3e71aff.0302141313.6020d9e5_at_posting.google.com...
> Hi
>
> I have one external procedure (library *.so for this is created using
> ORACLE 8.1.7.3 libraries). When called from 8.1.7.3 database, it works
> fine.
> Now I want to use the same external procedure from Oracle 9i(9.2.0.1)
> instance.
> For this I changed extproc related settings in listener.ora and
> tnsname.ora .
> But now I am getting the following errors
> ORA-06520: PL/SQL: Error loading external library
> ORA-06522: ld.so.1: extprocPLSExtProc_9i: fatal: libclntsh.so.8.0:
> open failed:
>
> Can somebody help on this issue.
> Is it not possible to use the same library for both Oracle8i &
> Oracle9i?
> or Do I need to set some variable....?
>
> Thanks
> Ashish
Received on Sat Feb 15 2003 - 04:26:36 CST