注册

下面这个存储过程的例子执行提示存在循环一样,有什么解决办法吗?

2023/06/01 790 9 已解决

下面这个存储过程的例子执行提示存在循环一样,有什么解决办法吗?

-- 达梦
DROP PROCEDURE IF EXISTS testEntry1;
CREATE PROCEDURE testEntry1(num in int)
AUTHID DEFINER
AS
/变量说明部分/
cc int;
BEGIN
cc:= num+1;
if cc%10 == 0 then
select cc;
end if;
if cc <10 THEN
CALL testEntry2(cc);
end if;
END;

DROP PROCEDURE IF EXISTS testEntry2;
CREATE PROCEDURE testEntry2(num in int)
AUTHID DEFINER
AS
/变量说明部分/
cc int;
BEGIN
cc:= num+1;
if cc%10 == 0 then
select cc;
end if;
if cc <10 THEN
CALL testEntry1(cc);
end if;

END;

CALL testEntry1(0);
DROP PROCEDURE IF EXISTS testEntry1;
DROP PROCEDURE IF EXISTS testEntry2;

回答 0
暂无回答
扫一扫
联系客服