After successfully making a connection to the database, I try to run a query using F5 Run as Script. This gives me an "Error - No connection" message in the output window and I am prompted with the error:
"Access violation at address 01B9F80C in module 'Toad.exe'. Read of address 0000000B."
I can click OK to this error, I cannot run the query, but I generally can continue using Toad. If I try to run the query again, the same thing happens.
If I run the query using F9 Execute as Statement, the query runs fine and I can get output. This is only an issue with my user login, on this computer. If I log into this computer with another user, I don't have this problem. If I log in with my own user on another computer, I don't have this problem.
Issue with limited active session setting for a particular user and conflict with Toad option setting for session threading. Toad may be trying to open more session than allowed for the user currently connected.
WORKAROUND 1:
Remove or increase any active session limitations defined for the particular Oracle user.
WORKAROUND 2:
Check the Oracle Transaction Options setting under View | Toad Options | Oracle | Transactions. The setting for "Execute scripts in Toad session" may need to be checked. The setting for "Execute queries in threads (Creates a separate session)" may need to be unchecked.
Depending on the session setting for a user and the Toad option setting running with F9 may or may not work. Similarly, depending on the setting running with F5 may or may not work.
Further details about Oracle Transaction Options settings are available in Toad for Oracle's help files.
