Debugger times out and Toad hangs with a "Probe: Timeout occurred" (4337382)

A "Probe: Timeout occurred" is recieved when debugging with TOAD, and/or Toad hangs and becomes non-responsive.

RESOLUTION 1:

When using Toad for Oracle 10.6 and newer, when connecting and debugging in an 8i database, please use a 9i or higher client.

RESOLUTION 2:

1. In versions prior to 9.0:
                                                      Select View | Options | Procedure Editor | Debugging.  
     In version 9.0 or after:
                                                      Select View | Toad Options | Debugger.

2. Increase the value for "Debug session time out" or set it to zero to turn it off.

3. Apply the changes and restart Toad.


RESOLUTION 3:

Add the setting (SERVER = DEDICATED) to the TNSnames.ora file. Below is a sample TNS entry using this setting:

testserver =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.1.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = testserver)
)
)

RESOLUTION 4:
Ensure the Oracle client used to make the connection is the same or a compatible version with server.

RESOLUTION 5:
Check the Initailisation Variables. e.g V_date := '01.01.0001';
This is not a correct default value for a data variable.