为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】: 8
【操作系统】：windows
【CPU】: 11th Gen Intel(R) Core(TM) i7-11700 @ 2.50GHz 2.50 GHz
【问题描述】*：我有多个存储过程，单独创建存储过程成功，如果通过批处理处理创建多个存储过程总是提示
-2007: 第 153 行, 第 1 列[CREATE]附近出现错误:
语法分析出错
也试了在上一个存储过程end; 添加/，提示
-2007: 第 151 行, 第 1 列[/]附近出现错误:
语法分析出错。

对应存储过程伪代码如下。
CREATE OR REPLACE PROCEDURE "MODEL"
(
i_root VARCHAR(255),
i_root_ids VARCHAR,
i_endpoints_up VARCHAR,
i_endpoints_down VARCHAR,
i_depth INT,
i_limit BIGINT) AS
DECLARE

current_depth int default 1;
BEGIN
SET current_depth = 1;

WHILE current_depth <= i_depth LOOP

INSERT INTO temp_search_graph (path, aid, atype, bid, btype, prop, all_prop, depth)
SELECT
JSON_ARRAY_APPEND(sg.path, '$', CONCAT(g.btype,':',g.bid)) AS path,
g.aid,
g.atype,
g.bid,
g.btype,
g.relationship AS prop,
JSON_ARRAY_APPEND(sg.all_prop, '$', g.relationship) AS all_prop,
sg.depth + 1 AS depth
FROM model_instance_relationship g
JOIN temp_search_graph_down_result sg ON g.aid = sg.bid AND g.atype = sg.btype
WHERE sg.depth = current_depth
AND JSON_CONTAINS(i_endpoints_down, JSON_ARRAY(g.btype))
AND (g.relationship='associate' OR g.relationship='own' OR g.relationship='contain')
AND NOT JSON_CONTAINS(sg.path, JSON_ARRAY(CONCAT(g.btype, ':', g.bid)));

insert into temp_search_graph_down_result select * from temp_search_graph;

truncate TABLE temp_search_graph;
SET current_depth = current_depth + 1;
END LOOP ;

INSERT INTO temp_search_graph_up_result (path, aid, atype, bid, btype, prop, all_prop, depth)
SELECT
JSON_ARRAY(CONCAT(btype, ':', bid), CONCAT(atype, ':', aid)) AS path,
aid,
atype,
bid,
btype,
relationship AS prop,
JSON_ARRAY(relationship) AS all_prop,
1 AS depth
FROM model_instance_relationship
WHERE btype = i_root
AND (JSON_LENGTH(i_root_ids) = 0 OR JSON_CONTAINS(i_root_ids, JSON_ARRAY(bid)))
AND JSON_CONTAINS(i_endpoints_up, JSON_ARRAY(atype))
AND (relationship='associate' OR relationship='own' OR relationship='contain')
LIMIT i_limit;

SET current_depth = 1;

WHILE current_depth <= i_depth LOOP

INSERT INTO temp_search_graph (path, aid, atype, bid, btype, prop, all_prop, depth)
SELECT
JSON_ARRAY_APPEND(sg.path, '$', CONCAT(g.atype,':',g.aid)) AS path,
g.aid,
g.atype,
g.bid,
g.btype,
g.relationship AS prop,
JSON_ARRAY_APPEND(sg.all_prop, '$', g.relationship) AS all_prop,
sg.depth + 1 AS depth
FROM model_instance_relationship g
JOIN temp_search_graph_up_result sg ON g.bid = sg.aid AND g.btype = sg.atype
WHERE sg.depth = current_depth
AND JSON_CONTAINS(i_endpoints_up, JSON_ARRAY(g.atype))
AND (g.relationship='associate' OR g.relationship='own' OR g.relationship='contain')
AND NOT JSON_CONTAINS(sg.path, JSON_ARRAY(CONCAT(g.atype, ':', g.aid)));

insert into temp_search_graph_up_result select * from temp_search_graph;

truncate TABLE temp_search_graph;
SET current_depth = current_depth + 1;
END LOOP ;

SELECT path as o_path, aid as a, atype as alabel, bid as b, btype as blabel, prop as o_link_prop, all_prop as o_link_prop_all, depth as o_depth FROM temp_search_graph_down_result
UNION ALL
select path as o_path, bid as a, btype as alabel, aid as b, atype as blabel, prop as o_link_prop, all_prop as o_link_prop_all, depth as o_depth from temp_search_graph_up_result;

DROP TABLE IF EXISTS temp_search_graph;
DROP TABLE IF EXISTS temp_search_graph_down_result;
DROP TABLE IF EXISTS temp_search_graph_up_result;
END;

CREATE OR REPLACE PROCEDURE "TEST222"
(
i_root varchar(255),
i_endpoints VARCHAR) AS
DECLARE

current_depth int default 1;

begin
INSERT INTO temp_mr_search_direct_up_result (atype, btype, amulti, bmulti, prop, all_prop, depth, path)
SELECT atype, btype, amulti, bmulti, relationship, JSON_ARRAY(relationship), 1, JSON_ARRAY(btype, atype)
FROM model_relationship
WHERE btype = i_root
AND JSON_CONTAINS(i_endpoints, JSON_ARRAY(atype))
AND (relationship = 'contain' or relationship = 'own' or relationship = 'associate');

SET current_depth = 1;

WHILE current_depth < 5 LOOP
INSERT INTO temp_mr_search_direct_up (atype, btype, amulti, bmulti, prop, all_prop, depth, path)
SELECT g.atype, g.btype, g.amulti, g.bmulti, g.relationship, JSON_ARRAY_APPEND(sg.all_prop, '$', g.relationship), depth + 1, JSON_ARRAY_APPEND(sg.path, '$', g.atype)
FROM model_relationship g
JOIN temp_mr_search_direct_up_result sg
ON JSON_CONTAINS(i_endpoints, JSON_ARRAY(g.atype))
AND g.btype = sg.atype
AND NOT JSON_CONTAINS(sg.path, JSON_ARRAY(g.atype))
AND sg.depth = current_depth
AND (g.relationship = 'contain' or g.relationship = 'own' or g.relationship = 'associate');

insert into temp_mr_search_direct_up_result(atype, btype, amulti, bmulti, prop, all_prop, depth, path) select atype, btype, amulti, bmulti, prop, all_prop, depth, path from temp_mr_search_direct_up;
truncate TABLE temp_mr_search_direct_up;
SET current_depth = current_depth + 1;
END LOOP ;

SELECT path AS o_path, btype AS alabel, atype AS blabel, bmulti as amulti, amulti as bmulti, prop AS o_link_prop, all_prop AS o_link_prop_all, depth AS o_depth
FROM temp_mr_search_direct_up_result
WHERE JSON_CONTAINS(i_endpoints, JSON_ARRAY(atype));
DROP TABLE temp_mr_search_direct_up_result;
DROP TABLE temp_mr_search_direct_up;
end;