PL/SQL Beautifier and CASE statement

[EngEar]

Hi,

I have a problem with formatting of CASE statement.
It is formatted as one line when used with RETURN statement, but when I use it with assignment formatting is pretty good.

Below is a example of such formatting:

FUNCTION test(in_value IN VARCHAR2) RETURN VARCHAR2 IS
      temp VARCHAR2(200);
   BEGIN
      temp := CASE in_value
                 WHEN val1_in THEN
                  val1_out
                 WHEN val2_in THEN
                  val2_out
                 ELSE
                  NULL
              END;

      RETURN CASE in_value WHEN val1_in THEN val1_out WHEN val2_in THEN val2_out ELSE NULL END;
   END test;

I want to use the "short" form of code (without the local variable), but after beautifying it is unreadable.

In this case Beautifier also doesn't honor the Right Margin parameter.

I use PL/SQL Developer Version 11.0.0.1762

Thanks

 

[Marco Kalter]

This is indeed not right. We'll fix it.