Formatting PL/SQL in SQLDev 20.2.0 - Unwanted Indentation after Comment - Solution?

This is a bug.

Workaround: append the following rule to Custom Format Arbori program:

fixComments: runOnce -> {

    var LexerToken = Java.type('oracle.dbtools.parser.LexerToken'); 

    var tokens  =  LexerToken.parse(target.input,true);  // parse with WS symbols

    var Token = Java.type('oracle.dbtools.parser.Token');

    var Substitutions = Java.type('oracle.dbtools.parser.Substitutions');

    var substitutions = new Substitutions(target.input);

    var commentEnd = 0;

    for( i = 0; i < tokens.length; i++ ) {

        if( commentEnd == 0 && (tokens[i].type == Token.COMMENT || tokens[i].type == Token.LINE_COMMENT) ) {

            commentEnd = tokens[i].end;

            continue;

        }

        if( tokens[i].content == " " && commentEnd != 0 ) {

            substitutions.put(tokens[i].begin,tokens[i].end,"");

            continue;

        }

        if( tokens[i].type != Token.WS )

            commentEnd = 0;   

    }

    target.input = substitutions.transformInput();

}

Witness it working:

This hack is based upon an observations that if I nuke the indentation of the line following a comment, then the format works properly. 

The Substitutions class is helpful when writing a translator, like in this example; therefore, it warrants little more explanation. It is basically a sugarcoated map of position intervals which content would be substituted with the mapped strings. The text substitution entries can be added in arbitrary order, and the Substitutions class takes care of applying them properly. For example, java program

public static void main( String[] args ) {

    Substitutions repl = new Substitutions("0123456789012345");

    repl.put(1,2,"[1,2)");

    repl.put(11,12,"[11,12)");

    System.out.println("**** repl.toString():");

    System.out.println(repl.toString());

    System.out.println("**** repl.transformInput():");

    System.out.println(repl.transformInput());

}

outputs:

**** repl.toString():

0

---

1

--->>>

[1,2)

---

234567890

---

1

--->>>

[11,12)

---

2345

**** repl.transformInput():

0[1,2)234567890[11,12)2345