次に、一例としてspSample1という名前のプロシージャのDDLを示します。
SHOW PROCEDURE spSample1; *** Text of DDL statement returned. *** Total elapsed time was 1 second. ----------------------------------------------------------------- CREATE PROCEDURE spSample1 (IN ip INTEGER, OUT op INTEGER) BEGIN DECLARE var_1 INTEGER; SELECT col1 INTO var_1 FROM tab_1 WHERE col_2 = ip; SET op = var1 * 10; END;