Print Thread
Error in PL/SQL Beautifier
#62128 10/22/20 02:36 PM
Joined: Sep 2019
Posts: 34
Spain
E
El Offline OP
Member
OP Offline
Member
E
Joined: Sep 2019
Posts: 34
Spain
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.


-------------------------------
Elias F.M.
Re: Error in PL/SQL Beautifier
El #62131 10/23/20 08:50 AM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
We'll fix it!


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.028s Queries: 14 (0.011s) Memory: 2.4956 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-10 11:40:16 UTC
Valid HTML 5 and Valid CSS