XML formatting

I’ve found that formatting certain SQL that contains XML functionality doesn’t work in the editor in version 10, whereas it did in 9.7. e.g.

select extractvalue (column_value,’/DATASET/TEXT’) text from xmltable (’/DATASET’ passing xmltype(‘hello’));

All the formatter seems to do is change the case. 9.7 also changed the alignment.

The formatter settings are the same in both versions. Is this possibly a bug?

This got broken somewhere around Oct 2008 indeed, but it has been fixed in a
recent formatter drop (qp5.dll version 5.138 or higher, possible not yet in



Thanks for that. I’ve temporarily replaced qp5.dll with the version from the 9.7 install and the formatter seems to work ok.