这个存储过程错在哪里了?
1 create or replace procedure ci
2 as
3 n_cust_id snap_cust_info.cust_id%TYPE;
4 begin
5 select cust_id into n_cust_id from snap_cust_info where input_date = to_char(sysdate,'yyyymmdd');
6 if nvl(n_cust_id,123) then
7 insert into tb_cust_prem_info select poh_cust_id,insan_amt from snap_policy_info where poh_cust_id=n_cust_id;
8 end ci;
------------------------------------------------------------------------
报错是:
LINE/COL ERROR
-------- -----------------------------------------------------------------
8/5 PLS-00103: Encountered the symbol "CI" when expecting one of the
following:
if