select into语句之踩坑（一）报错

来源：互联网发布：手机导航电子狗软件编辑：程序博客网时间：2024/06/08 00:38

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

1 0