Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    19

    Question Unanswered: External Procedure error

    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?

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    Library object ?

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •