Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XMLSequence with lowercase tags

850838Mar 28 2011 — edited Mar 31 2011
hi everyone

i'm working on a procedure to export some data as XMLSequence. the query works, but i'd like to have some things modified on the way the result looks like:

1.
generated XML-tags are UPPERCASE, how can i force oracle to generate lowercase XML-tags?
postprocessing is no option.

2.
lists are exported this way:

<NAMEOFELEMENT>
<NAMEOFELEMENT_ROW>
<NAMEOFELEMENT_ROW>
<NAMEOFELEMENT_ROW>
</NAMEOFELEMENT>

but i'd like oracle to use the following naming:

<NAMEOFELEMENT_LIST>
<NAMEOFELEMENT>
<NAMEOFELEMENT>
<NAMEOFELEMENT>
</NAMEOFELEMENT_LIST>

means, instead of adding "_ROW" to the name of each data row in the export, the enclosing XML-tag should have a "_LIST" added to it's name.

the outermost xml-element is named <ROW>, i was able to instruct oracle to rename it to whatever i need, using the additional XMLFormat('MYNAME'), so i'm confident there're more ways to configure the generated XML-output.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2011
Added on Mar 28 2011
6 comments
409 views