Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

what is cause of ORA-25128: No insert/update/delete in Oracle?

 
jagrutkumar dalwadi
Ranch Hand
Posts: 83
Hibernate Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have got following error in production environment:

SQL state [99999]; error code [25128]; ORA-25128: No insert/update/delete on table with constraint (SYS_C0031978) disabled and validated
; nested exception is java.sql.SQLException: ORA-25128: No insert/update/delete on table with constraint (SYS_C0031978) disabled and validated.

SYS_C0031978: is constraint which sees particular field is not null. this constraint is disable currently.

Try to give some view on this.
 
Sam Falzon
Greenhorn
Posts: 5
Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tom Kyte explains this...

Question regarding "constraint state"
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!