The following example creates a valid SQL procedure named sp_sample1 with the following parameters and local variables:
Variable Type | Variable Name |
---|---|
IN | ip |
OUT | op |
local variable | var1 |
Because the parameter type for ip is not specified, it defaults to IN. This procedure does not contain any condition handlers.
CREATE PROCEDURE sp_sample1( ip INTEGER, OUT op INTEGER) BEGIN DECLARE var1 INTEGER; SELECT col1 INTO var1 FROM tab1 WHERE col2 = ip; SET op = var1 * 10; END;