Informix创建执行和删除带参数的存储过程实例

Informix创建执行和删除带参数的存储过程实例

 

--创建带参数存储过程second_string
CREATE PROCEDURE second_string(input CHAR(256))
RETURNING CHAR(256);
DEFINE var1 CHAR(256);
DEFINE var2 INT;
LET var1 = input;
LET var2 = 1;
WHILE var2 = 1
    IF substr(var1, 0, 1)  = ' ' THEN
      RETURN substr(var1, 2);
    END IF;
    LET var1 = substr(var1, 2);
END WHILE;
END PROCEDURE;
--执行带参数存储过程second_string
execute procedure second_string('gAAAAAAAAAAAAAA 0.0000');
--删除带参数存储过程second_string
drop procedure second_string(CHAR);