You can write a routine in an external language that the
database server supports. After you create a routine, you register
the routine with a CREATE FUNCTION or CREATE PROCEDURE statement.
The
CREATE FUNCTION and CREATE PROCEDURE statements specify the location
of the external routine, as follows:
For C UDRs, the location is the full pathname of the shared-object
module, qualified with the name of the C function that implements
the function or procedure.
For Java™ UDRs, location
is the name of the .jar file, followed by the
name of the Java class and the
name of the method within that class, including its arguments.
For example, the following figure shows a CREATE FUNCTION
statement that registers a user-defined function called abs_eq() that
is written in C. The corresponding C function is in a shared-object
file called abs.bld.Figure 1: Registering an external-language function
