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,221
Member
Offline
Member
Joined: Aug 1999
Posts: 22,221
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.044s Queries: 14 (0.023s) Memory: 2.4994 MB (Peak: 3.0425 MB) Data Comp: Off Server Time: 2024-05-20 21:52:27 UTC
Valid HTML 5 and Valid CSS