Aginity存储过程错误

Question

这可能是个外行的问题。尽管如此，我还是在网上冲浪，但没能通过。在Aginity中运行简单存储过程时，我会收到以下错误

CREATE OR REPLACE PROCEDURE test() 
RETURNS VARCHAR(10) 
LANGUAGE NZPLSQL AS
BEGIN_PROC
DECLARE 
BEGIN 
RETURN "SUCCESS" 
END
END_PROC;

运行上述程序时没有出现错误。

只在执行时获得错误，如下所示

EXECUTE TEST();

错误：

ERROR [01000] NOTICE:  plpgsql: ERROR during compile of TEST near line 3

ERROR [HY000] ERROR:  missing ; at end of SQL statement

谢谢

Answer 1

CREATE OR REPLACE PROCEDURE test() 
RETURNS VARCHAR(10) 
LANGUAGE NZPLSQL AS
BEGIN_PROC
-- No need a DECLARE when you don have to declare anything
BEGIN 
RETURN "SUCCESS" ; -- you just need a semi colon!
END; -- also here
END_PROC;