Minor package editor bug

[amannering]

Using PL/SQL Developer 5.1.4.728, there's a slight glitch in the parser used to build the function treeview in the package editor.

If you have a function that has a PL/SQL CASE statement in it, the tree doesn't go any further than that function - i.e. any defined below it in the package are not visible in the treeview.

Below is an example - commenting out the case statement gets the third function to display. Indeed, as you type the case statement into function2, the one below it disappear from the tree as soon as the "case" is recognised by the syntax highlighter.

create or replace package body test is

  function function1(p_test IN NUMBER) RETURN NUMBER
  AS
  BEGIN
    RETURN p_test;
  END;

  function function2(p_test IN NUMBER) RETURN NUMBER
  AS
  BEGIN
    CASE
      WHEN p_test = 1 THEN
      BEGIN
        NULL;
      END;
    END CASE;
    RETURN p_test;
  END;

  function function3(p_test IN NUMBER) RETURN NUMBER
  AS
  BEGIN
    RETURN p_test;
  END;

end test;

Andrew

 

[amannering]

Just seconds after posting this, I got the notification about 5.1.6 - and guess what: it's fixed!

Andrew