Analytics 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!

Missing XML Tags in XML file - ODI

714579Jul 26 2011 — edited Jul 27 2011

I am trying to create an XML file from an Oracle table. We have ODI 10.1.3.6.2 on oracle 10gr2 db and all Connections are succesful and XML file is created with one issue. 2 of the XML tags (fields) are missing. These 2 fields are in XML schema (metadata) and they are mapped correctly and successfuly.

I have identified that these 2 tags are missing in the file because they are populated with NULL in the source table. I would expect to see empty tags in the XML file instead of no tags at all. Is this an ODI bug? is there a work around for this?

I am using an ODI proc to create the file after I load the XML schema via an interface. Procesure code is below. 2 parameters are passed for XML file name and XML schema name. This is working perfectly for all other XML files.

CREATE XMLFILE "#p_XML_FILE" FROM SCHEMA #p_XML_SCHEMA

Thank you all in advance for all your help

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2011

Added on Jul 26 2011

#business-intelligence-applications, #data-integrator, #file, #in, #odi, #system-management-and-integration, #xml

1 comment

433 views