The Code Explorer in the Editor in SQL Navigator 6.0 does not recognize block labels. Procedures which are declared behind a block label doesn't appear in the code explorer.
Example:
Create the following package an body and open it in the editor. The second procedure "behind_label" in the code explorer cannot be seen.
create or replace package code_explorer_test1 as
procedure code_explorer;
end code_explorer_test1;
/
create or replace package body code_explorer_test1 as
procedure code_explorer is
begin
begin <<Label>>
dbms_output.put_line ( 'Test' );
end Label;
end;
procedure behind_label is
begin
null;
end;
end code_explorer_test1;
/
WORKAROUND:
None.
STATUS:
Waiting for fix in a future release of SQL Navigator for Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center