Scalable Database Server, HiRDB Version 8 UAP Development Guide

[Contents][Index][Back][Next]

9.2.3 Defining the Java stored routine

To define a Java stored routine, use CREATE PROCEDURE or CREATE FUNCTION. CREATE PROCEDURE or CREATE FUNCTION defines association of a Java method with a procedure name or function name.

For details about CREATE PROCEDURE or CREATE FUNCTION, see the HiRDB Version 8 SQL Reference manual.

Figure 9-7 shows an example of Java stored routine definition.

Figure 9-7 Example of a Java stored routine definition

[Figure]

Organization of this subsection
(1) Java stored procedure
(2) Java stored function

(1) Java stored procedure

Use CREATE PROCEDURE to register a Java method as a Java stored procedure.

(2) Java stored function

Use CREATE FUNCTION to register a Java method as a Java stored function.