Dropping an External Routine

A user-defined routine (UDR) written in C language or in the Java™ language is called an external routine. External routines 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 routine. You must also hold the Usage privilege on the external programming language in which the UDR is written. See the section Granting the EXTEND Role for additional information about the EXTEND 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 procedure 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.