The Create Procedure Statement

As mentioned in the SQL Reference Guide, the create procedure statement has language-specific syntax rules for line continuation, string literal continuation, comments, and the final terminator. These syntax rules follow the rules discussed in this chapter. For example, the final terminator is a semicolon (;). Although the preprocessor treats the create procedure statement as a single statement, you must terminate all statements in the body of the procedure with a semicolon as is an Embedded SQL/Ada statement.

The following example shows a create procedure statement that follows the Embedded SQL/Ada syntax rules:

exec sql
  create procedure proc (parm integer) as
  declare
    var integer;
  begin
    if parm > 10 then -- use Ada comment delimiter
      message 'Ada strings cannot continue over lines';
      insert into tab values (:parm);
    endif;
  end;