Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes what is cause of ORA-25128: No insert/update/delete in Oracle? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "what is cause of ORA-25128: No insert/update/delete in Oracle?" Watch "what is cause of ORA-25128: No insert/update/delete in Oracle?" New topic
Author

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

jagrutkumar dalwadi
Ranch Hand

Joined: Mar 26, 2009
Posts: 83

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

Joined: Apr 29, 2011
Posts: 5

Tom Kyte explains this...

Question regarding "constraint state"
 
 
subject: what is cause of ORA-25128: No insert/update/delete in Oracle?