Re: Beautifier and Views with PL/SQL functions in the with clause

[Tichij]

Hi Marco,

Today I remembered this discussion in beta forum...
3 versions have already been released, almost 7 years have passed, after it...
Maybe there’s a chance to see it in the patch release of 16 version?..
Thanks

 

[Marco Kalter]

I would think this had already been fixed. Can you provide an example where this does not work?

 

[Tichij]

try to beautify this example:

create or replace view test_view as
with
function fd (p_datum in date) return varchar2 is
begin
return to_char(p_datum,'DD-MM-YYYY');
end fd;
select fd(sysdate) datum from dual;

At least I get "PL/SQL Beautifier could not parse text" error when try.

 

[Marco Kalter]

Thanks. We'll try to fix it.