Error in PL/SQL Beautifier - 01/31/22 04:54 PM
Hello:
With this code PL/SQL Beautifier fails
If the v_stmt_str line is deleted or the carriage return is removed it works.
I reported it in August 2020 via email. In the beta of version 15 it continues badly. I would appreciate it if you would fix this bug.
Best Regards,
With this code PL/SQL Beautifier fails
SQL Query
CREATE OR REPLACE PROCEDURE test_format IS PROCEDURE p_example IS CURSOR cursor_dummy(c_p_version VARCHAR2) IS SELECT XMLELEMENT("siiLR:RegistroLRBajaCobrosMetalico", XMLELEMENT("sii:PeriodoLiquidacion"), XMLELEMENT("siiLR:Contraparte")) the_xml FROM dual a; v_stmt_str VARCHAR2(32767); v_the_result xmltype; BEGIN v_stmt_str := 'AS "siiLR", AS "sii", AS "soapenv")'; END; BEGIN NULL; END;
If the v_stmt_str line is deleted or the carriage return is removed it works.
I reported it in August 2020 via email. In the beta of version 15 it continues badly. I would appreciate it if you would fix this bug.
Best Regards,