java.sql.BatchUpdateException: ORA-02290: check...

2019独角兽企业重金招聘Python工程师标准>>>

---ORA-02290: check constraint (ZSDXAPP.SYS_C0025749) violated
---- 查询序列当前值
select seqname.currval from dual 
select PHONE_SMS_SEQ.currval from dual 
 
----查询序列下一值
select seqname.nextval from dual
select t_course_master_seq.nextval from dual  

SELECT MAX(id) FROM T_COURSE_MASTER ;

---3、创建触发器
 drop trigger t_course_master_tri;
 create or replace trigger t_course_master_tri
      before insert on t_course_master     /*触发条件：当向表dectuser执行插入操作时触发此触发器*/
          for each row                       /*对每一行都检测是否触发*/
          begin                                  /*触发器开始*/
            select t_course_master_seq.nextval into :new.id from dual;   /*触发器主题内容，即触发后执行的动作，在此是取得序列dectuser_tb_seq的下一个值插入到表dectuser中的userid字段中*/
end;

转载于:https://my.oschina.net/fxdemon/blog/135546