Try OpenEdge Now
skip to main content
SQL Development
Stored Procedures and Triggers : Stored procedure fundamentals
 

Stored procedure fundamentals

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
parameter_decl
{ IN | OUT | INOUT }parameter_name data_type
* Java snippet