I am generating XML in Oracle PL/SQL with the DBMS_XMLGEN package:
OPEN base_cursor FOR SELECT * FROM foo; base_context := dbms_xmlgen.newcontext(base_cursor); base_xml := dbms_xmlgen.getxmltype(base_context, dbms_xmlgen.none);
My problem is that whatever I do I always get the tag names in upper case. To maintain compatibility with things further downstream, I need them to be in lower case. Is there any way I can fix this?
I know there is an option for this in DBMS_XMLQUERY, but the docs says it is not recommended to use that package.