1 Reply Latest reply on Oct 11, 2016 11:13 PM by thatJeffSmith-Oracle

    [4.2 EA] Formatter chokes on XMLAttribute & XMLForest functions

    Sentinel

      I've encountered another pair of constructs that the code formatter has issues with, the XMLAttribute and XMLForest functions

       

      Here's the XMLAttribute code before:

      select xmlelement(root, xmlattributes('MyValue' "attribute")) xml from dual;
      

       

      And After formatting:

      select xmlelement(root, xmlattributes('MyValue'
      /*** Syntax Error at line 0, column 47
      
      select xmlelement(root, xmlattributes('MyValue' "attribute")) xml from dual;
                                                     ^^^                          
      
      Expected: 
       ***/ "attribute")) xml from dual;
      

       

      Here's the XMLForest code before:

      select xmlelement(root,xmlforest(1 a, 2 b)) from dual;
      

       

      And after formatting:

      select xmlelement(root,xmlforest(1
      /*** Syntax Error at line 0, column 34
      
      select xmlelement(root,xmlforest(1 a, 2 b)) from dual;
                                        ^^^              
      
      Expected:
      ***/ a, 2 b)) from dual;