sql语句如下
insert into tb_customer_info(id,CUSTOMER_NAME,system_customer_no,CUSTOMER_TYPE)
select
TAX_SEQUENCE.NEXTVAL,
a.CUSTOMER_NAME,
a.system_customer_no,
3 from(select
fund.sys_code||'虚拟客户' as CUSTOMER_NAME,
'XN'||fund.sys_code as system_customer_no
from tb_output_fund_product fund
where fund.fundraising_channel='3'
and 'XN'||fund.sys_code not in
(select cust.system_customer_no from tb_customer_info cust))a;
在存储过程报错,在sql窗口正常执行