注册

执行函数的时候报错信息只有1条语句执行失败,请问怎么看详细信息

yq 2024/09/13 304 0

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: v8.1
【操作系统】:win11
【CPU】: AMD Ryzen 7 4800H with Radeon Graphics 2.90 GHz
【问题描述】*:
执行函数的时候报错信息只有1条语句执行失败,请问怎么看详细信息

--转化函数,需要定义好字段类型,再循环插入 DECLARE V_AGENCY_ID varchar(38); V_FISCAL_YEAR varchar(4); V_MOF_DIV_CODE varchar(9); V_MOF_DIV_NAME varchar(360); V_AGENCY_CODE varchar(21); V_AGENCY_NAME varchar(300); V_AGENCY_ABBREVIATION varchar(300); V_AGENCY_LEADER_PER_NAME varchar(60); V_FI_LEADER varchar(60); V_FI_LEADER_CONT varchar(200); V_AGENCY_TEL varchar(200); V_ZIP varchar(6); V_AGENCY_ADD varchar(300); V_PARENT_ID varchar(38); V_LEVEL_NO Integer; V_IS_LEAF Integer; V_START_DATE Date; V_END_DATE Date; V_IS_ENABLED Integer; V_UPDATE_TIME DateTime; V_IS_DELETED Integer; V_CREATE_TIME DateTime; V_VERSION varchar(38); V_VERSION_NAME varchar(400); V_BIZ_KEY varchar(38); c1 CURSOR FOR SELECT IFNULL(GUID,''), IFNULL(YEAR,''), IFNULL(ADMDIVCODE,''), IFNULL(ADMDIVNAME,''), IFNULL(CODE,''), IFNULL(NAME,''), IFNULL(ABBREVIATION,''), IFNULL(FZR,''), IFNULL(CWFZR,''), IFNULL(CWFZRPHONENO,''), IFNULL(PHONENO,''), IFNULL(POSTALCODE,''), IFNULL(ADDRESS,''), IFNULL(PARENT_GUID,''), IFNULL(LEVEL_NUM,0), IFNULL(ISLEAF,0), IFNULL(STARTDATE,now()), IFNULL(LASTDATE,now()), IFNULL(ENABLED,0), IFNULL(UPDATE_TIME,now()), IFNULL(IS_DELETED,0), IFNULL(CREATE_TIME,now()), IFNULL(VERSION,''), IFNULL(VERSION_NAME,''), IFNULL(BIZ_KEY,'') from JCZL330600.ENTERPRISE; BEGIN OPEN c1; LOOP FETCH c1 INTO V_AGENCY_ID, V_FISCAL_YEAR, V_MOF_DIV_CODE, V_MOF_DIV_NAME, V_AGENCY_CODE, V_AGENCY_NAME, V_AGENCY_ABBREVIATION, V_AGENCY_LEADER_PER_NAME, V_FI_LEADER, V_FI_LEADER_CONT, V_AGENCY_TEL, V_ZIP, V_AGENCY_ADD, V_PARENT_ID, V_LEVEL_NO, V_IS_LEAF, V_START_DATE, V_END_DATE, V_IS_ENABLED, V_UPDATE_TIME, V_IS_DELETED, V_CREATE_TIME, V_VERSION, V_VERSION_NAME, V_BIZ_KEY; EXIT WHEN c1%NOTFOUND; IF REGEXP_LIKE(V_START_DATE, '^\d4-\d2-\d2') THEN else V_START_DATE = now(); end if; insert into BAS_AGENCY_INFO(AGENCY_ID, FISCAL_YEAR, MOF_DIV_CODE, MOF_DIV_NAME, AGENCY_CODE, AGENCY_NAME, AGENCY_ABBREVIATION, AGENCY_LEADER_PER_NAME, FI_LEADER, FI_LEADER_CONT, AGENCY_TEL, ZIP, AGENCY_ADD, PARENT_ID, LEVEL_NO, IS_LEAF, START_DATE, END_DATE, IS_ENABLED, UPDATE_TIME, IS_DELETED, CREATE_TIME, VERSION, VERSION_NAME, BIZ_KEY, AGENCY_LEADER_PER_CONT, FI_LESSOR, FI_LESSOR_CONT, ADMIN_MAN_DEP_CODE, ADMIN_MAN_DEP_NAME, FIN_MAN_DEP_CODE, FIN_MAN_DEP_NAME, AGENCY_ADM_LEVEL_CODE, AGENCY_ADM_LEVEL_NAME, MOF_DEP_CODE, MOF_DEP_NAME, IND_CODE, IND_NAME, AGENCY_TYPE_CODE, AGENCY_TYPE_NAME, AGENCY_CLASS_CODE, AGENCY_CLASS_NAME, AGENCY_IDEN_CODE, AGENCY_IDEN_NAME, IS_PRE_DEPAR_FIN_ACCOUNTS, IS_PRE_FIN_REP_GOV_DEP, IS_PRE_STA_OWN_ASSE_REP_ADM, IS_BUDGETING_UNIT, IS_REFE_CIV_SERV_LAW_MANA, IS_PERSON_QUO, IS_FISCAL_UNIT, IS_LAST_INST) values(V_AGENCY_ID, V_FISCAL_YEAR, V_MOF_DIV_CODE, V_MOF_DIV_NAME, V_AGENCY_CODE, V_AGENCY_NAME, V_AGENCY_ABBREVIATION, V_AGENCY_LEADER_PER_NAME, V_FI_LEADER, V_FI_LEADER_CONT, V_AGENCY_TEL, V_ZIP, V_AGENCY_ADD, V_PARENT_ID, V_LEVEL_NO, V_IS_LEAF, V_START_DATE, V_END_DATE, V_IS_ENABLED, V_UPDATE_TIME, V_IS_DELETED, V_CREATE_TIME, V_VERSION, V_VERSION_NAME, V_BIZ_KEY, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0); END LOOP; CLOSE c1; END;
回答 0
暂无回答
扫一扫
联系客服