创建存储过程中第二个片段插入sql报错请问是什么原因

v_sql:='INSERT INTO tb_user_cert_name
select a.user_id,a.attr_code,a.attr_value,
to_char(a.start_date,''yyyymmdd'') start_date,to_char(a.end_date,''yyyymmdd'') end_date
from ucr_crm2_cdc.tf_f_user_item@lcllink9 a
where a.attr_code =''CertName''
and sysdate between start_date and end_date;
execute immediate v_sql;
commit;
v_sql:='INSERT INTO tmp_user_cert -- 这里报错了请问一下这段sql是哪里有问题
select a.user_id,a.attr_code,a.attr_value,
substr(a.start_date,1,8) start_date,substr(a.end_date,1,8) end_date
from FORGRA.TAB_CBSS_D_USER_ITEM_ZY_'||V_day||'@LCLLINK1 A
where A.ATTR_CODE =''USE_CUST_NAME'';
execute immediate v_sql;
commit;

```

wendal

1楼•2925天前

报什么错

qq_36699b6f 2楼•2925天前

encountered the ''insert'' when expecting one of the following:*&=-+</> at in is mod remainder not rem <an exponent(**)><> or!=or~=>=<=<> and or like kike2·····

qq_36699b6f 3楼•2925天前

报错是：encountered the ''insert'' when expecting one of the following:*&=-+</> at in is mod remainder not rem <an exponent(**)><> or!=or~=>=<=<> and or like kike2·····

wendal

4楼•2925天前

end_date后面缺单引号

qq_36699b6f 5楼•2925天前

不缺引号，两个v_sql 交换顺序都是第二个insert报错

wendal

6楼•2925天前

v_sql:='INSERT INTO tb_user_cert_name
 select a.user_id,a.attr_code,a.attr_value,
 to_char(a.start_date,''yyyymmdd'') start_date,to_char(a.end_date,''yyyymmdd'') end_date
 from ucr_crm2_cdc.tf_f_user_item@lcllink9 a
 where a.attr_code =''CertName''
 and sysdate between start_date and end_date'; // 这个单引号,难道不需要匹配的?

请先登陆