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;