|Monte on Jun 16, 2009 at 12:12:07 PM (# 1)|
Never mind. I figured it out.
I forgot to do a commit in my DB IDE. the ExecuteNonQuery was waiting for the transaction to complete. Since there was no commit, the transaction didn't complete.
omega160 on Feb 3, 2011 at 2:51:04 PM (# 2)
Can you explain furthur how you did this....code example? I am having the exact same issue?
Monte on Feb 4, 2011 at 5:18:10 AM (# 3)
The code sample above does work. If I remember right, I just had to do a commit in my actual DB IDE. So try doing a commit on whatever DB you're using. If anyone has made modifications to the database through the IDE, have them do a commit. That's what fixed the issue for me.
omega161 on Feb 4, 2011 at 6:09:24 AM (# 4)
So basically if I had a SQLPlus session up to my oracle database and did an update in table but never did a commit or quit the SQLPlus session and then tried to do an update on the same table via my application I would get the hanging. If I do a commit in SQLPlus then execute an update from my application it shouldnt hang, correct??
omega161 on Feb 4, 2011 at 9:21:56 AM (# 5)
Thanks for pointing me in the right direction, all appears to be working now.
Monte on Feb 4, 2011 at 1:35:05 PM (# 6)
No problem. As you can see, the original solution took me about two hours to figure out after I made the initial post.