Beautifier bug OPEN SYS_REFCURSOR

[stwo]

Hi,

i'm using PL SQL Developer Version 16.0.0.2142. The beautifier is adding empty lines in specific constellations. You have to OPEN a SYS_CURSOR, but not FETCH it in a LOOP. See the following example:

CREATE OR REPLACE PACKAGE cur_beautify IS

END cur_beautify;
/
CREATE OR REPLACE PACKAGE BODY cur_beautify IS

  FUNCTION read_customers RETURN SYS_REFCURSOR IS
    l_cur SYS_REFCURSOR;
  BEGIN
    OPEN l_cur FOR
      SELECT customer_id id,
             name name
        FROM customers;

    RETURN l_cur;
  END read_customers;

END cur_beautify;
/

The beautifier would add an empty line between "FROM customers;" and "RETURN l_cur;" every time it is called.
Slightly different example but still the same effect (the empty line is added after "FROM customers;"):

CREATE OR REPLACE PACKAGE cur_beautify IS

END cur_beautify;
/
CREATE OR REPLACE PACKAGE BODY cur_beautify IS

  PROCEDURE read_customers(p_cur_out SYS_REFCURSOR) IS
  BEGIN
    OPEN p_cur_out FOR
      SELECT customer_id id,
             name name
        FROM customers;

  END read_customers;

END cur_beautify;
/

 

[Marco Kalter]

We'll fix it!