Formatter is weird with FORALL and EXECUTE IMMEDIATE

dgs!

Member³
It seems that the EXECUTE IMMEDIATE is not getting carried to the next line.

The formatter is doing this:
FORALL i IN tbl.first .. tbl.last EXECUTE IMMEDIATE v_sql USING tbl(i).readmit_key, tbl(i).pat_id, tbl(i)... ETC.

I would like it to do this:
FORALL i IN tbl.first .. tbl.last
EXECUTE IMMEDIATE v_sql USING tbl(i).readmit_key,tbl(i).pat_id, tbl(i)... ETC.
 
It seems that problem still not fixed in Version 12.0.7.1837
Expected :

SQL:
BEGIN
  -- NoFormat Start
  FORALL idx IN 1 .. l_bal.count
    EXECUTE IMMEDIATE(l_sql) USING IN l_bal(idx).balance, l_bal(idx).rowid1;
  -- NoFormat End
END;

Got:

SQL:
BEGIN
  FORALL idx IN 1 .. l_bal.count EXECUTE IMMEDIATE(l_sql) USING IN l_bal(idx).balance, l_bal(idx).rowid1
    ;
END;
 
Back
Top