If I use xmlnamespaces with double-quotes (") around the identifier the beautifier casues an error. If I remove them the beautifier works fine.
For the use of identifiers like "StUF" (mixed upper- and lowercase) then double-quotes are necessary to read the XML.
The code works, just the beautifier doesn't... "The beautifier caused an error."
It would also be nice (wish) if I can make the beautifier puts the "columns" on a new line, like the code above.
PL/SQL Developer Version 11.0.5.1775
For the use of identifiers like "StUF" (mixed upper- and lowercase) then double-quotes are necessary to read the XML.
The code works, just the beautifier doesn't... "The beautifier caused an error."
Code:
xmltable(xmlnamespaces('http://www.egem.nl/StUF/sector/lvo/0312' as "LVO",
'http://www.egem.nl/StUF/StUF0301' as "StUF"),
'/LVO:vrgDi01IntrekkenAanvraag/LVO:stuurgegevens' passing xmltype(w.message_data)
columns functie varchar2(30) path 'StUF:functie'
) as extract_functieIt would also be nice (wish) if I can make the beautifier puts the "columns" on a new line, like the code above.
PL/SQL Developer Version 11.0.5.1775
