XML formatting

Toad for Oracle
1

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?

2

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
Toad).

Thanks,

Andre

3

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