错误(5,58):PL/SQL:ORA-00923:FROM关键字未在预期位置找到

Question

我创建了一个触发器，每当接种疫苗的儿童数量超过一个地区可用的疫苗数量时，就会引发错误。

CREATE OR REPLACE TRIGGER VERIF_VAC_KID
BEFORE INSERT ON KID_VACCINE
FOR EACH ROW
DECLARE
KIDS NUMBER(6,0);
QUANT NUMBER(6,0);
BEGIN
SELECT COUNT(K.KID_ID) INTO KIDS, q.Quantity INTO QUANT FROM Kid_vaccine v
inner join Vaccine_quant q ON q._Id = v.Camp_Id where Vp.Svc_Id = :NEW.Camp_Id Group By q.Id, q.Quantity, q.region_ID;
IF(KIDS > QUANT) THEN
Raise_Application_Error(-20207, 'ERROR');
END IF;
END;
/

当我运行触发器时，我得到错误

Error(5,58): PL/SQL: ORA-00923: FROM keyword not found where expected

"from"的位置似乎正确，我不知道我可能错了什么，请帮助

Answer 1

对我来说，你似乎需要更换这个

SELECT COUNT(K.KID_ID) INTO KIDS, q.Quantity INTO QUANT FROM ...

用这个

SELECT COUNT(K.KID_ID), q.Quantity INTO KIDS, QUANT FROM ...