Was this helpful?
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
    var integer;
    if parm > 10 then -- use Ada comment delimiter
      message 'Ada strings cannot continue over lines';
      insert into tab values (:parm);
Last modified date: 06/10/2024