Re: ORA-06522 file or directory not found

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 Mon Mar 10 2003 - 03:10:13 CST