RAISE statement in debugger causes TOAD to hang when Break On Exceptions is set to false.
Steps to reproduce the problem:
1] Go to View|Toad Options|Debugger| and set Break On Exceptions to false
2] Create the following procedure and function:
CREATE OR REPLACE PROCEDURE sp_Test IS
tmpVar NUMBER;
BEGIN
tmpVar := fn_Test('Testing');
select 'Test'
into tmpVar
from dual;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END sp_Test;
/
CREATE OR REPLACE FUNCTION fn_test(strTest VARCHAR) RETURN NUMBER IS
tmpVar NUMBER;
BEGIN
tmpVar := strTest;
RETURN tmpVar;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END fn_test;
/
3] Go to the Schema Browser and double click the procedure to debug(sp_Test )
3] r-click and select Execute pl-sql with debugger
4] Click 'yes' => Toad hangs
WORKAROUND
None.
STATUS
Waiting for fix in a future release of Toad For Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center