This section explains how to define stored procedures and stored functions.

Be sure to create the necessary RDAREA spaces before defining stored procedures and stored functions. For details about the operation of stored procedures and stored functions, see the HiRDB Version 8 System Operation Guide.

Stored procedures and stored functions can code processing procedures in SQL or Java. Those coded in SQL are called SQL stored procedures and SQL stored functions, while those coded in Java are called Java stored procedures and Java stored functions.

For details about Java stored procedures and Java stored functions, see 9. Java Stored Procedures and Java Stored Functions.

Note

If an error occurs while an SQL stored procedure or SQL stored function is being executed, processing of the SQL stored procedure or SQL stored function terminates at the point when the error occurred (the programs exits from control of the SQL stored procedure or SQL stored function). Therefore, error-handling processes cannot be specified in SQL stored procedures and SQL stored functions.

Organization of this section

4.3.1 Defining a stored procedure

4.3.2 Defining a stored function

4.3.3 Defining and deleting stored functions