File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Spring in Action this week in the Spring 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"
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: what is cause of ORA-25128: No insert/update/delete in Oracle?