问题遇到的现象和发生背景
触发器异常无法新增数据，写死的也无法新增和关联表取值的数据也是无法新增
运行结果及报错内容
CREATE OR REPLACE TRIGGER EB.T_EB_TR_SYS_DN_PENDING_HIS
AFTER INSERT ON EB.T_EB_SYS_DN_PENDING_H
FOR EACH ROW
DECLARE
V_URL VARCHAR2(200);
BEGIN
SELECT T.LOOKUP_VALUE_NAME INTO V_URL FROM T_EB_DB_LOOKUP_VALUE T WHERE T.LOOKUP_TYPE_CODE='VMD_TO_PARA_URL' AND T.LOOKUP_VALUE_CODE='1';
INSERT INTO T_IS_WF_HIS_INFO
(PENDING_ID,
CREATED_DATE,
LAST_UPDATED_BY,
LAST_UPDATED_TIME,
HANDLE_TEXT,
PROCESS_STATUS,
PROCESS_RUNTIME_ID,
SYSTEM_ID,
PROCESS_PENDING_ID,
CREATED_BY,
PEND_AUTOR,
TOPIC,
PROCESS_MODULE_ID,
PROCESS_KIND_GUID,
PROCESS_KIND_NAME,
OWNER,
OWNER_NAME,
LAST_AUTOR,
INITIATE_DATETIME,
PROCESS_NAME,
CURRENT_STEP_ID,
CURRENT_STEP_NAME,
URL,
MAIN_VER,
SUB_VER,
ACTIVE_DATE,
MAXAPPROVALHOURS,
ACTIVE_MONTH,
MAXAPPROVALDATE,
CREATED_TIME,
PENDING_TYPE
)
SELECT :NEW.PENDING_ID,
SYSTIMESTAMP,
:NEW.USER_ID,
:NEW.LAST_UPDATED_DATE,
:NEW.REMARK,
1,
:NEW.LINK_BU_ID,
'VMD',
:NEW.PENDING_ID,
:NEW.CREATOR,
:NEW.USER_ID,
WN.WF_NODE_NAME TOPIC,
DP.WF_ID,
SW.WF_ID,
SW.WF_NAME,
DP.CREATOR,
U2.EMP_NAME,
DP.CREATOR,
DP.CREATED_DATE,
SW.WF_NAME,
WN.WF_NODE_ID,
WN.WF_NODE_NAME,
V_URL,
NULL,
NULL,
DP.CREATED_DATE,
0,
NULL,
NULL,
DP.CREATED_DATE,
1
FROM T_IS_WF_HIS_INFO WI
INNER JOIN EB.T_EB_SYS_DN_PENDING DP ON WI.PENDING_ID=DP.PENDING_ID
INNER JOIN BOM.T_EAP_SYS_USER U2 ON DP.CREATOR=U2.USER_ID
INNER JOIN EB.T_EB_SYS_DN_WF_NODE WN ON DP.WF_NODE_CODE=WN.WF_NODE_CODE
INNER JOIN EB.T_EB_SYS_WF SW ON DP.WF_ID=SW.WF_ID;
END;
我的解答思路和尝试过的方法
根据表查询看是否存在关联关系
我想要达到的结果
新增成功 不管是写死的还是关联的数据
