• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Update the Inserted record while Autocommit is false

 
Azrael Noor
Ranch Hand
Posts: 384
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
First
Autocommit is FLASE

then Insert a record

then update same record in same session and same user id

commit it

Insertion is done succesfully but Updation on same record is not done

Same query is working when i later done updation

Why so?




 
Wendy Gibbons
Bartender
Posts: 1110
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
it sounds like a bug in your code, can you produce a small working sample that displays this.
all it would do is exactly as you have described in your description. The bit about it working later does not need to be shown, as we don't need to see the working code.
 
Azrael Noor
Ranch Hand
Posts: 384
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sir i have marked the status as solved
the database was new to me and their was some trigger which was not letting me doing this and i was not aware of this.

Thank you

 
Wendy Gibbons
Bartender
Posts: 1110
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thank you for letting us know.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic