This section discusses the fundamentals of writing stored procedures.
The SQL CREATE PROCEDURE statement provides the basic framework for stored procedures. Use the CREATE PROCEDURE statement to submit a Java code snippet that will be compiled and stored in the database.
The CREATE PROCEDURE statement uses the following syntax:
Syntax
CREATE PROCEDURE [owner_name.]procname ([parameter_decl[ , ...]])[ RESULT (column_name data_type[,...])][ IMPORT
java_import_clause] BEGIN
java_snippet END
