When working with debugger, the executables lines and break points set are not working properly. A break point is set on a line that is suppose to execute. But the debugger does not stop at the break.
Example: Run in SQL Editor with debug toggled on.
CREATE OR REPLACE PROCEDURE
testing_lines
IS
v1 VARCHAR2(100) := 'var 1';
v2 VARCHAR2(100) := 'var 2';
v3 VARCHAR2(100) := 'var 3';
BEGIN
DBMS_OUTPUT.PUT_LINE('v1='||v1);--<<<<<<<DBMS_OUTPUT.PUT_LINE('v2='||v2);
DBMS_OUTPUT.PUT_LINE('v3='||v3);
END;
Incorrect tracing in debugger when object created with title on 2 or more lines lines.
In this example the title is created on two lines so it throws off the tracing and the executable line settings. So, while "DBMS_OUTPUT.PUT_LINE('v1='||v1);" is an executable line, it will not stop on the break placed here because the executable line notation is off by a line and notes it as not executable. This is becuase the line before it is "BEGIN", which is not an executable line.
"CREATE OR REPLACE PROCEDURE
testing_lines "
versus
"CREATE OR REPLACE PROCEDURE testing_lines "
This will run correctly:
CREATE OR REPLACE PROCEDURE testing_lines
IS
v1 VARCHAR2(100) := 'var 1';
v2 VARCHAR2(100) := 'var 2';
v3 VARCHAR2(100) := 'var 3';
BEGIN
DBMS_OUTPUT.PUT_LINE('v1='||v1);--<<<<<<<DBMS_OUTPUT.PUT_LINE('v2='||v2);
DBMS_OUTPUT.PUT_LINE('v3='||v3);
END;
WORKAROUND:
None
STATUS:
This issue is fixed in Toad for Oracle 9.0. This version can be downloaded here.
