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
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center