I'm trying to compile the following function:

CREATE OR REPLACE FUNCTION shell(cmd IN VARCHAR2)
RETURN PLS_INTEGER
AS
EXTERNAL LIBRARY EXTPROCSHELL_LIB
NAME "extprocsh"
LANGUAGE C
PARAMETERS (cmd STRING);


but keep getting an error that says EXTPROCSHELL_LIB needs to be declared. Somewhere I read that this probably means that the shared library doesn't exist and try recreating it.

Our DBA assures me that he created the library in the Oracle home lib directory and I do see the compiled C program there and also saw the path of his library creation and everything looks fine.

Any suggestions here?

Hello,

do you have created a library object with the same name ?
See "CREATE LIBRARY ...."

The error you have posted does not mean, that you don´t have created the lib in the oracle directory.
Its says, that Oracle can not find the library object that points to the library in the oracle directoy ....

Hope that helps ?

Manfred Peter
Alligator Company GmbH
http://www.alligatorsql.com