Dropping External Functions

A user-defined function (UDF) written in C language or in the Java™ language is called an external function. External functions must include the External Routine Reference clause that specifies a shared-object filename. By default, only users to whom the DBSA has granted the built-in EXTEND role can create or drop an external function. You must also hold the Usage privilege on the external programming language in which the UDF is written. See the section Granting the EXTEND Role for additional information about the EXTEND role security feature. See the section Language-Level Privileges for the syntax of the USAGE ON LANGUAGE clause for the C language or for the Java language.

To remove the executable version of a C language routine from shared memory, call the IFX_UNLOAD_MODULE function. To replace the executable version of a C routine with another routine, call the IFX_REPLACE_MODULE function. Both of these built-in functions are described in UDR Definition Routines.