Okay – this was an annoyance but not big enough for me to find out who owns the
licensing info and work it through my organization.
I just retested this in Toad 10.6. What I now see is that when I try to step
over a procedure that includes an exception, the debugger jumps to the exception
handler of the called procedure where what I would prefer is that if the
exception is handled, it be ignored.
Here’s how I have my debugger options configured:
Here’s my test case where what I do is run break_control with a break set at
‘Before call’ and then a step over of the “break_test” call.
CREATE OR REPLACE PACKAGE GMNA_BASELINE_POC1.rg_test_break
CREATE OR REPLACE PACKAGE BODY rg_test_break
v_chr VARCHAR2 (10);
v_chr := ‘Hello’;
SELECT dummy INTO v_chr FROM DUAL WHERE 1 = 2;
DBMS_OUTPUT.put_line (‘In Exception’);
DBMS_OUTPUT.put_line (‘Before call’);
break_test; DBMS_OUTPUT.put_line ('After call');
On Mon, May 2, 2011 at 1:00 PM, Jeff Smith wrote:
You might want to open a support case with Quest. This board is informal, so to expect an answer to every question from a Quest person is a little unreasonable. If you can provide the test case again, I’d be happy to try your scenario in v10.6 and v11 – assuming it’s a Toad issue and not an Oracle one.