Posted By: El Error in PL/SQL Beautifier - 10/22/20 02:36 PM
Hello:

With this code in a Program Window, PL/SQL Beautifier fails


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.
Posted By: Marco Kalter Re: Error in PL/SQL Beautifier - 10/23/20 08:50 AM
We'll fix it!
© Allround Automations forums