ORA-00001: unique constraint violated异常处理
程序中保存数据时报错，ORA-00001:uniqueconstraint(xxxx)violated先是查看数据库结构，最近也没什么改动，开发环境也正常，测试环境就报这个错后来发现主键id是自增的，查询序列的下个值 selecttable_seq.nextval fromdual发现这...
ORA-28117: integrity constraint violated – parent record not found
文档解释ORA-28117:integrityconstraintviolated–parentrecordnotfoundCause:trytoupdate/insertachildrecordwithnewforeignkeyvalues,butthecorrespondingparentrowisno...
ORA-08175: discrete transaction restriction violated (string)
文档解释ORA-08175:discretetransactionrestrictionviolated(string)Cause:Anattemptwasmadetoperformanactionthatisnotcurrentlysupportedinadiscretetransaction.Action:Roll...
ORA-38911: unique constraint (string.string) violated
文档解释ORA-38911:uniqueconstraint(string.string)violatedCause:AnINSERTstatementwithaCHANGE_DUPKEY_ERROR_INDEXhinttriedtoinsertaduplicatekeyintoatable.Action:Either...
ORA-02437: cannot validate (string.string) – primary key violated
文档解释ORA-02437:cannotvalidate(string.string)–primarykeyviolatedCause:attemptedtovalidateaprimarykeywithduplicatevaluesornullvalues.Action:removetheduplicat...
ORA-00001: unique constraint (string.string) violated
文档解释ORA-00001:uniqueconstraint(string.string)violatedCause:AnUPDATEorINSERTstatementattemptedtoinsertaduplicatekey.ForTrustedOracleconfiguredinDBMSMACmode,youma...
ORA-02292: integrity constraint (string.string) violated – child record found
文档解释ORA-02292:integrityconstraint(string.string)violated–childrecordfoundCause:attemptedtodeleteaparentkeyvaluethathadaforeignkeydependency.Action:deleted...
ORA-02291: integrity constraint (string.string) violated – parent key not found
文档解释ORA-02291:integrityconstraint(string.string)violated–parentkeynotfoundCause:Aforeignkeyvaluehasnomatchingprimarykeyvalue.Action:Deletetheforeignkeyora...
ORA-02293: cannot validate (string.string) – check constraint violated
文档解释ORA-02293:cannotvalidate(string.string)–checkconstraintviolatedCause:analtertableoperationtriedtovalidateacheckconstrainttoapopulatedtablethathadnocom...