Progress
SQL-92
Guide and Reference


Stored Procedure Basics

This section discusses how to get started 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.

This is syntax for the CREATE PROCEDURE statement.

SYNTAX
CREATE PROCEDURE [ owner_name.]procname 
   ( [ parameter_decl [ , ...  ]  ]  )
   [ RESULT ( column_name data_type [ , ... ] ) ]
   [ IMPORT 
      java_import_clause ]
   BEGIN
      java_snippet
   END 

parameter_decl

SYNTAX
{ IN | OUT | INOUT } parameter_name data_type  


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095