Failure in dynamic dependency from external procedure

Greetings...

I am having difficulties with executing an external procedure on the Sun platform with Oracle 8.1.5.

It appears that the extproc listener is correctly picking up the need to execute the .so file which was compiled. However, it seems to be failing to pick up a secondary dependency which was dynamically linked into the .so which I wrote. (I get an ld.so.1 error complaining that the secondary .so was not found)

Both the main external procedure .so file and the secodnary .so which it depends upon reside in the same directory, which is part of the LD_LIBRARY_PATH variable for the oracle user. Calling the external procedure .so file from a C program front end within this directory succeeds without difficulty.

Is there something simple which I am missing here? I haven't been able to glean useful information from the Oracle documentation for this problem. I'm not certain what login/environment is used for the execution of the external procedure, and why it might be failing to pick up a .so in the LD_LIBRARY_PATH if things are run from the Oracle user's login environment.

Anybody run across this before? Any suggestions?

TIA for any help,

Jeremy Beal Received on Tue May 30 2000 - 00:00:00 CDT