Hi there,

I have successfully registered and used a C-library with Oracle 10g. The
only problem I have is:

extproc does not recognize changes in the .so file and keeps using old
cached versions. Whenever I alter the .so file (e.g. by recompilation),
I have to kill the extproc process explicitly to let Oracle recognize
the new library. Another way is: logging off and on again :-(

The listener.ora looks like this:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = extproc)
(ORACLE_HOME = /opt/oracle/product/10.1.0/db_1)
(PROGRAM = extproc)

(ENVS="EXTPROC_DLLS=ANY,DEBUG_MODULES=ALL,DEBUG_FI LE=/tmp/ext_proc.log")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbserver1)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)


My question: Is there an easy way to tell the extproc process not to use
cached versions of .so files?