达梦8

AS
BEGIN
/执行体/
TRUNCATE TABLE PUINFOSOC.ETPS_INFO;

INSERT INTO PUINFOSOC.ETPS_INFO pu (etps_name, reg_no, fr_name, unisc_id, enty_type)
SELECT etps.etps_name, etps.reg_no, etps.fr_name, etps.unisc_id, ‘3’ FROM appeal.gs_etps_info etps where etps.unisc_id !=‘’;

INSERT INTO PUINFOSOC.ETPS_INFO pu (etps_name, reg_no, fr_name, unisc_id, enty_type)
SELECT pe.name, pe.reg_no, en.persn_name, pe.unisc_id, ‘2’ FROM appeal.gs_pe_info_enty pe inner join appeal.gs_pe_operator_enty en on en.pe_id=pe.pe_id where pe.unisc_id !=‘’;

END;

里面跑都能跑但是存储过程一编译就报不支持语句类型