This topic 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

parameter_decl

{ IN | OUT | INOUT }parameter_name data_type