Beautifier: Error on nested case statements

[christianbalz]

I receive a message when i execute PL/SQL Beautifier with the code bellow.

SELECT CASE BRAN.BRANCH_LEVEL
                 WHEN 1 THEN
                    CASE FN_UDF_FUNCID_VALUE('XX','XX', BRAN.BRANCH_CODE )
                         WHEN '2' THEN 'XXXX'
                    END
                 WHEN 2 THEN
                    CASE FN_UDF_FUNCID_VALUE('XX','XX', BRAN.BRANCH_CODE )
                         WHEN '3' THEN 'XXXX'
                         WHEN '4' THEN 'XXXX'
                    END
                 WHEN 3 THEN
                    CASE FN_UDF_FUNCID_VALUE('XX','XX', BRAN.BRANCH_CODE )
                         WHEN '5' THEN 'XXXX'
                    END
                 WHEN 4 THEN
                    CASE FN_UDF_FUNCID_VALUE('XX','XX', BRAN.BRANCH_CODE )
                         WHEN '6' THEN 'XXXX'
                         WHEN '7' THEN 'XXXX'
                         WHEN '8' THEN 'XXXX'
                         WHEN '9' THEN 'XXXX'
                    END
              END AS XXX_XXX_XXX
         FROM IFVW_BRANCH BRAN
        WHERE BRAN.BRANCH_CODE = pi_xxx;

Kind regards,

Christian

 

[Marco Kalter]

There is indeed a problem with nested case expressions. This will be fixed.