|
|
|
This section discusses how to get started writing stored procedures.
The FairCom DB 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 syntax for the CREATE PROCEDURE statement is:
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
Note: When creating stored procedures, the key words BEGIN, RESULT, IMPORT and END should start at the first column of the line.
See Also
