Beautifier with "using" clause

[edmsos]

Hello,

Year ago we had an issue with beautifier with "using" clause in open sys_refcursor for l_sql using....:https://forums.allroundautomations....bb=showflat&Main=16273&Number=62237#Post62237

Which was fastly fixed - Thanks!

Now we have similiar issue with "using" clause in execute immediate l_sql_count into l_rowcount using....:

All using clause is in one line, and it can be hundreds of symbols. WARNING: You can reproduce only when there are many elements in using a clause.
In our case it should be one item per line.

function get_smth return sys_refcursor is
  l_sql      clob;
  l_rowcount number;
begin
  l_sql := 'select.....';
  execute immediate l_sql
    into l_rowcount
    using l_cols(1).col_value, l_cols(2).col_value, l_cols(3).col_value, l_cols(4).col_value, l_cols(5).col_value, l_cols(6).col_value, l_cols(7).col_value, l_cols(8).col_value, l_cols(9).col_value, l_cols(10).col_value, l_cols(11).col_value, l_cols(12).col_value, l_cols(13).col_value, l_cols(14).col_value, l_cols(15).col_value, l_cols(16).col_value, l_cols(17).col_value, l_cols(18).col_value, l_cols(19).col_value, l_cols(20).col_value, l_cols(21).col_value, l_cols(22).col_value, l_cols(23).col_value, l_cols(24).col_value, l_cols(25).col_value, l_cols(26).col_value, l_cols(27).col_value, l_cols(28).col_value, l_cols(29).col_value, l_cols(30).col_value, l_cols(31).col_value, l_cols(32).col_value, l_cols(33).col_value, l_cols(34).col_value, l_cols(35).col_value, l_cols(36).col_value;

Beautifier config attached
View attachment sensus_beautifier.txt

 

[Marco Kalter]

We'll fix that too!