Database Software

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!

selecting null value into xmlelement

416627Feb 22 2005 — edited Aug 23 2005

I'm trying to select from relational tables into xml. All is fine EXCEPT that I cannot show NULL values as
<element></element> .

I have a workaround in nvl(column, ' ') which shows up as
<element> </element> 

Most functions will not even list the null value:
XMLFOREST, SYS_XMLGEN, DBMS_XMLGEN

Is there something that would work?
Should I try DBMS_XMLQUERY?
Would it make a difference if I had an object type (UDT) defined on the relational query?
Other comments, suggestions, or bright remarks?

Thanks in advance, Oracle db version 9.2.0.5 on AIX.
-tom

btw I searched this forum back 'till Aug 2004, and did not see an answer. Other people have asked this question, tho.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 20 2005

Added on Feb 22 2005

#performance-availability, #xml-db

5 comments

2,617 views