Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> URGENT: Running external procedure compiled using Oracle 8.1.7 libraries from 9i

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

From: Ashish <ashish_tiwari_at_infosys.com>
Date: 14 Feb 2003 13:12:13 -0800
Message-ID: <d3e71aff.0302141312.1e1f50b0@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 Fri Feb 14 2003 - 15:12:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US