Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: URGENT: Running external procedure compiled using Oracle 8.1.7 libraries from 9i
Hi
You must recompile your library:
You can use make file in ../rdbms/demo directory:
Example (my file name is palaute.*):
make -f demo_rdbms.mk extproc_callback SHARED_LIBNAME=palaute.so
OBJS=palaute.o
Regards Kari
"Ashish" <ashish_tiwari_at_infosys.com> wrote in message
news:d3e71aff.0302141312.1e1f50b0_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 - 16:43:31 CST