为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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;