5,889
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE FUNCTION FUNC_TEST (
in_opId VARCHAR(20),
in_id VARCHAR(20)
)
RETURNS INTEGER
LANGUAGE SQL
BEGIN ATOMIC
DECLARE v_id VARCHAR(20);
DECLARE v_PId VARCHAR(20);
IF in_opId = in_id THEN
RETURN 0;
END IF;
SET v_id = in_id;
WHILE v_id IS NOT NULL DO
SET v_PId =( SELECT PARENT_ID FROM JFIT.T_SYS_RESOURCE WHERE ID = v_id);
IF v_PId = in_opId THEN
RETURN 0;
END IF;
SET v_id = v_PId;
END WHILE;
RETURN 1;
END;
[CREATE - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "E v_id VARCHAR(20" 后面找到异常标记 ")"。预期标记可能包括:"END-OF-STATEMENT"。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82
16:58:16 [DECLARE - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "BEGIN-OF-STATEMENT" 后面找到异常标记 "DECLARE v_PId VARCHAR"。预期标记可能包括:"<values>"。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82
16:58:16 [IF - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "BEGIN-OF-STATEMENT" 后面找到异常标记 "IF"。预期标记可能包括:"<variable_set>"。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82
16:58:16 [END - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "END IF" 后面找到异常标记 "END-OF-STATEMENT"。预期标记可能包括:"JOIN <joined_table>"。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82
16:58:16 [SET - 0 row(s), 0.000 secs] [Error Code: -206, SQL State: 42703] "V_ID" 在使用它的上下文中无效。. SQLCODE=-206, SQLSTATE=42703, DRIVER=4.15.82
16:58:16 [WHILE - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "BEGIN-OF-STATEMENT" 后面找到异常标记 "WHILE v_id IS NOT NULL DO"。预期标记可能包括:"<space>"。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82
16:58:16 [IF - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "BEGIN-OF-STATEMENT" 后面找到异常标记 "IF"。预期标记可能包括:"<variable_set>"。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82
16:58:16 [END - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "END IF" 后面找到异常标记 "END-OF-STATEMENT"。预期标记可能包括:"JOIN <joined_table>"。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82
16:58:16 [SET - 0 row(s), 0.000 secs] [Error Code: -206, SQL State: 42703] "V_ID" 在使用它的上下文中无效。. SQLCODE=-206, SQLSTATE=42703, DRIVER=4.15.82
16:58:16 [END - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "END WHILE" 后面找到异常标记 "END-OF-STATEMENT"。预期标记可能包括:"JOIN <joined_table>"。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82
16:58:16 [RETURN - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "BEGIN-OF-STATEMENT" 后面找到异常标记 "RETURN"。预期标记可能包括:"<values>"。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82
16:58:16 [END - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "END" 后面找到异常标记 "END-OF-STATEMENT"。预期标记可能包括:"JOIN <joined_table>"。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82
16:58:16 [@ - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] 在 "@" 后面找到异常标记 "END-OF-STATEMENT"。预期标记可能包括:"JOIN <joined_table>"。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.15.82
... 13 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 13 errors]