Beautifier behavior FORALL

Rdrdev

Member
Hello,

I found a glitch while using the Beautifier on these structure on version 15:

SQL:
BEGIN
     FORALL i IN 1 .. 6
        UPDATE  MY_TABLE mt
        SET    mt.COL1 = 'test'
              ,mt.dat  = SYSDATE
        WHERE  mt.COL2 = 'test2';
        COMMIT;
END;

If I were to add the SAVE EXCEPTIONS Keyword, the beautifier would produce a real ugly thing, please see.

SQL:
BEGIN
     FORALL i IN 1 .. 6
        SAVE EXCEPTIONS UPDATE  MY_TABLE mt SET mt.COL1 = 'test'
        , mt.dat    = SYSDATE WHERE mt.COL2 = 'test2';
     COMMIT;
END;

On previous version (14 for example) the beautifier was acting rightfully.

Could you take look and fix that for next version? :) or tell me if there is a workaround to solve this?
Best Regards,
 
Back
Top