PL/SQL Beautifier : Nested Case in SELECT statements

[orca777]

PL/DEV 5.1.4.730, NT 4.0, Oracle 9.0.1.4.0

The nested Case Statement is not correct formatted:

CASE
         WHEN st_business_type IN ('TR', 'RE', 'CS', 'NT') THEN
          tr_sec_price
         ELSE
          CASE
         WHEN nvl(tr_sec_price, 0) != 0 AND nvl(st_tcy, ' ') != '  ' THEN
          tr_sec_price
         ELSE
          mcb_sr.sh_sr_price(st_se_id,
                             st_tcy,
                             st_entity_id,
                             st_trade_date,
                             st_tran_date,
                             st_fx_rate_tcy,
                             st_se_unit_code,
                             st_trade_date - 30,
                             least(st_trade_date + 30, st_tran_date))
       END END st_sec_price_tcy,

You see the 'when' of the second case at the same ident level.

Regards Carl r.

 

[Marco Kalter]

We'll fix it.