From original >>>
needing to physically commit the insert statement in
its session before the result is visible to other sessions.
Welcome to the world of threading and session management. By definition from Oracle, what you do in one session should not be visible until after a commit.
So if you execute via threads and those threads use different sessions, then that’s exactly how it’s supposed to work. You cannot say what happens in Toad while it’s running should always be visible to me – not when you add threads and have threads running
in other sessions.
What you might be really asking for – is there a way to run threads in the same sessions as the main Toad session? Look under options (or do options search)
for thread ….