Data got commited in another/same session, cannot update row

Always get - Data got commited in another/same session, cannot update row

 

When I delete a row from Sql Developer tool I am getting the following error:

 

Query: DELETE FROM "SONORA"."PI_GENERIC_CAPTURE" WHERE ROWID = 'AAADg9AAFAAAAPIAAC' AND ORA_ROWSCN = '1136534' and ( "ASSIGNEEID" is null or "ASSIGNEEID" is not null )

 

One error saving changes to table "SONORA"."PI_GENERIC_CAPTURE":

Row 1: Data got commited in another/same session, cannot delete row.

Possible Solutions:

1.       Log off sql server and restart it.

2.        Go to Tools -> Preferences -> Database -> Object viewer

 

 

2 comments:

Anna Schafer said...

nice bLog! its interesting. thank you for sharing.... loan on inheritance

brittanymlemay said...

You completed a few fine points there. I did a search on the subject and found nearly all persons will go along with with your blog. slickcashloan

Post a Comment