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;
Last modified date: 01/30/2023