我创建触发器的语句:
create or replace trigger TRIG_DAT_DD before insert on DAT_DD_TEMP for each row begin SELECT DAT_DD_SEQ.NEXTVAL INTO : NEW.ID FROM DUAL;end TRIG_DAT_DD;
insert into select from 语句:
insert into DAT_DD_TEMP (BNK_NUM,SUBJT_NUM,ACCT_NUM,CUST_NM,CUST_NUM,CRNCY_CD,ENDING_BAL,ACTL_RT,ACCRUE_BASIS,ACCRUE_FREQ,CRDT_FREQ,PMT_ARNG,ACCT_TYP) select so.ID as BNK_NUM,vb.ITM_NUM as SUBJT_NUM,vb.CUST_ACCT_NUMBER2 as ACCT_NUM,vb.CUST_NM as CUST_NM,vb.CUST_NUM as CUST_NUM,bc.ID as CRNCY_CD,vb.ACCT_BAL_AMT as ENDING_BAL, NVL(bpb.BAS_RT,0)+NVL(bpf.FLT_PCT,0) as ACTL_RT,'30/360' as ACCRUE_BASIS,'Q20' as ACCRUE_FREQ,'Q20' as CRDT_FREQ, decode(vb.ITM_NUM,'205107','B','205108','C','A') as PMT_ARNG ,'L' as ACCT_TYP from VIRGO.VIRGO_BAS_DEMD_DEP_DTL vb left join ALMS.SYS_ORG so on vb.INSTN_NUM = so.ORG_CD left join ALMS.BAS_CRNCY bc on vb.CRNCY_CD = bc.NMRC_CRNCY_CD left join VIRGO.V_BAS_PUB_DEP_BAS_RT_INFO bpb on vb.ITM_NUM = bpb.ITM_NUM and vb.CRNCY_CD = bpb.CRNCY_CD left join VIRGO.V_BAS_PUB_DEP_FLT_RT_INFO bpf on vb.ITM_NUM = bpf.ITM_NUM and vb.CRNCY_CD = bpf.CRNCY_CD
使用JDBC执行这两个语句就报这个错
但是我在plsql里 先创建在执行就没有问题求解答
java.sql.SQLException: ORA-04098: 触发器 'ALMS.TRIG_DAT_DD' 无效且未通过重新验证 报这个错