"ORA-19011: Character string buffer too small" doing select xmlelement???
526531Aug 3 2006 — edited Oct 5 2007Apparently there is a 4K limit on the amount of XML that can be produced doing a select with SQL/XML syntax, or so it appears. That is pretty disappointing. It makes this feature uselful only for demos. 256K would be a much more realistic limit for real-world applications.