SPL procedures with no return values

SPL procedures with no return values are only accessible through the JDBC CallableStatement interface. SPL procedures with no return values can use OUT parameters. The syntax for creating such a procedure is:

CREATE PROCEDURE spl_udr ([IN/OUT] arg0 datatype0, ...,
                         [IN/OUT] argN datatypeN);
...

END PROCEDURE;

For example, the following SQL statement creates an SPL procedure with two OUT parameters and one IN parameter:

CREATE PROCEDURE myspl (OUT arg1 int, arg2 int, OUT arg3 int);
LET arg1 = arg2;
LET arg3 = arg2 * 2;
END PROCEDURE;