Skip to Main Content

SQL & PL/SQL

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!

Generating XML with namespace

Arnd S.Feb 16 2017 — edited Feb 21 2017

Hi everyone,

with PLSQL i try to build a valid XML from our DB data. I have a default namespace and an additional namespace "de" which should be defined in the top element of the resulting XML (xmlns=...). In the code i try to build this xml from the bottom to the top, creating the leafes of the XML tree first. The last step would be the creation of the top element including the namespace definition. However, this seems not to work since the xmlconcat function does accept XML elements with de namespace. It throws an exception with LPX-00234 (namespace not declared). I know that i could just add those namespace definition to all the elements that use it. However that would waste the XML. So i am looking for another way, maybe by turning off this namespace check until i do create the top element?

Thank you in advance for any hint,

Arnd

This post has been answered by Paulzip on Feb 17 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2017
Added on Feb 16 2017
11 comments
452 views