Little bug

[over]

PL/SQL Developer do not understand constructions like this:

FOR c_res IN c_amorts(p_live_fond => p_live_fond CASE WHEN p_live_fond = '3' then p_live_fond else null end)
    LOOP
...
END LOOP;

So, Beautifier and Content window do not work propertly.

 

[Marco Kalter]

We'll fix it.

 

[over]

I can fix it, but i have a lot of code, writen in this style. Can you teach Developer recognise this code in next versions?

 

[Makker]

That's what Marco meant, as I understand it. Although as kind of a Pl/Sql-purist I would never code something like this. I have to look many times to understand what it's doing here. It's also hard to debug. I would use a help-variable l_live_fond to fill seperately and then give it as a parameter. THen with the debugger you can watch the variable before calling the cursor or function/procedure.

Regards,
Martien