Re: ORA-06522 file or directory not found

In the end it was just a matter of compiling the .so correctly as 64 bit. Here is the syntax I used.

export INSTALLDIR=/home/opdd/snmp_dev
cc -o snmp.so GetPrinterStatus.o -bE:GetPrinterStatus.exp -bM:SRE -bnoentry -q64
 -L$INSTALLDIR/local/lib -lsnmp -I/usr/include/sys -I$INSTALLDIR/local/include/u
cd-snmp -I/usr/local/include -I/usr/include/sys -I$INSTALLDIR/ucd-snmp-4.1.2/snm
plib -I$INSTALLDIR/local/lib -L$INSTALLDIR/local/lib -I$INSTALLDIR/ucd-snmp-4.1.
2/agent -I$INSTALLDIR/ucd-snmp-4.1.2/agent/mibgroup -Daix4 -O -q64

johnleslie_at_madasafish.com (John Leslie) wrote in message news:<4412dd31.0303100110.522b7fa1_at_posting.google.com>...
> Here is what is happening
>
> I am having problems with an external procedure under 64 bit Oracle
> 9.2.0.1.0 on AIX 4.3.3
>
> ERROR at line 1:
> ORA-06520: PL/SQL: Error loading external library
> ORA-06522: No such file or directory
> ORA-06512: at "CNAM.FUNCTION_CALL_SNMP", line 0
> ORA-06512: at line 10
>
> The shared library is in the correct directory and oracle has
> permissions to access it.
>
> I have the following set in the listener.ora entry for PLSExtProc
> (ENV = "EXTPROC_DLLS=ANY")
>
>
> The problem seems to be that the C function acesses other C functions
> which are stored in the shared library.
>
> Indeed I have no problem accessing the shared library (.so) if I
> amended the C code to just do a return 0.
>
> The shared library has been recompiled to 64 bit.
>
> I can send the shared library if required
>
> All works fine under 8.1.7 32 bit.
>
>
>
>
>
>
>
> johnleslie_at_madasafish.com (John Leslie) wrote in message news:<4412dd31.0303071301.49c48c7f_at_posting.google.com>...
> > Anyone essle seen this error when calling an external procedure on Oracle 9.2?
> >
> > John
Received on Tue Mar 11 2003 - 05:29:50 CST