oracle - oracle函数错误pls-00103

Question

编译此函数时收到以下错误:

Error(19,8): PLS-00103: Encountered the symbol ";" when expecting one of the following: loop

CREATE OR replace FUNCTION EXP_NOW
RETURN NUMBER
IS
  cprod   NUMBER;
  dexp    DATE;
  prodexp NUMBER := 0;
  CURSOR prodsd IS
    SELECT cod_prod,
           dat_exp
    FROM   produse;
BEGIN
    OPEN prodsd;

    LOOP
        FETCH prodsd INTO cprod, dexp;

        EXIT WHEN prodsd%NOTFOUND;

        IF ( dexp <= SYSDATE ) THEN
          prodexp := cprod;
        END IF;
    EXIT LOOP;

    CLOSE prodsd;

    RETURN prodexp;
END; 

有人能帮我吗？这真令人沮丧。

Answer 1

您可以尝试使用END LOOP而不是EXIT LOOP吗？基本上，您使用LOOP和END LOOP来打开/关闭循环结构；您可以在其中使用EXIT WHEN。