为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: --03134284172-20240321-222308-20093
【操作系统】:openEluer22.03
【CPU】: 虚拟机
【问题描述】*:执行sql脚本后不能够退出数据库命令行,提示:The script file is not complete,last sql has not been executed.
文件内容为:
WHENEVER SQLERROR EXIT ROLLBACK;
-- Function structure for getRoleChildLst
CREATE OR REPLACE FUNCTION "rtvitrunk"."getRoleChildLst"
("rootId" varchar(100)) RETURN CLOB
AS
DECLARE
sTemp CLOB;
sTempChd CLOB;
nLoop INT;
BEGIN
SET sTemp = rootId;
SET sTempChd = TO_CHAR(rootId);
SET nLoop = 0;
WHILE nLoop < 15 && sTempChd is not null LOOP
SET nLoop = nLoop + 1;
SET sTemp = concat(sTemp,',',sTempChd);
SELECT LISTAGG(id, ',') INTO sTempChd FROM rtv_sub_admin where FIND_IN_SET(parent_id, sTempChd)>0;
END LOOP ;
RETURN sTemp;
END;
exit;
程序末尾空行以后加一个/