SQL Developer

SQL Developer EA3, JDK 1.6.0_04, Win XP SP 2

I have just noticed that one of our packaged applications has PL/SQL reserved words for column names and queries of these columns confuse the code folding in the package body. For example, there is a table with a column called FUNCTION and in the package body there is code as follows:

FUNCTION GetETypeClassCode
...
  IF ... THEN
...
  ELSE
...
    SELECT function
      INTO etypeclass_code
      FROM pa_system_linkages
     WHERE function = X_system_linkage ;
...
  END IF;
...
END GetEtypeClassCode;
 
FUNCTION Get_Org_Window_Title
...

There are no code folding nodes identified in the GetEtypeClassCode function (although both the IF and the SELECT should be) and the function itself is not identified as a node. If I take a custom copy of the code and change the FUNCTION column name to another column in the table, reopening the custom package body for edit does identify the function, the if and the select as folding nodes.

theFurryOne