begin
select (case when p.product_code in ('A03XXX', 'MPXXX04000003') then v_claimType:='PD'
when p.product_code in ('YGGHJGJHGJD01', 'MP0JKHHJ7110006') then v_claimType:='GL'
end) into v_claimType
from XXX_PLOLICY p
where p.policy_no = v_case.report_no
and p.report_no = v_case.policy_no
and p.case_no = v_case.case_no
and p.case_times = v_case.case_times;
EXCEPTION
WHEN NO_DATA_FOUND THEN
v_claimType := '';
END;
报错:
PL/SQL: ORA-00905: 缺失关键字
PL/SQL: SQL Statement ignored
begin
select (case when p.product_code in ('A03', 'MP04000003') then 'PD'
when p.product_code in ('D01', 'MP07110006') then 'GL'
end) into v_claimType
from clmp_policy p
where p.policy_no = v_case.report_no
and p.report_no = v_case.policy_no
and p.case_no = v_case.case_no
and p.case_times = v_case.case_times;
EXCEPTION
WHEN NO_DATA_FOUND THEN
v_claimType := '';
END;
主要是select into