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!

Loading XML files that don't have/are missing namespace declarations

Simon GaddOct 30 2009 — edited Nov 3 2009

Hi Folks.

I am trying to load XML files into my database.

I have registered the schemas and all is fine when I load xml files that have the following in the header...

<?xml version="1.0" encoding="UTF-8"?>
<RTDR xmlns:tadig-gen="https://infocentre.gsm.org/TADIG-GEN" xmlns="https://infocentre.gsm.org/TADIG-RTDR">
   <RTDRFileHeader>

My problem is that I am also receiving files with headers like this...

<?xml version="1.0" encoding="UTF-8" ?>
<RTDR>
<RTDRFileHeader>

When I try and load these into my table which has an XMLTYPE column associated with the registered RTDR schema, I get...

ORA-30937: No schema definition for 'RTDR' (namespace '') in parent '/'

My question is this.

Is it possible to get Oracle to load a file without the normal namespace declarations or would you say that the file without the namespace decparations is incorrect?

Many thanks

Kind regards

Simon Gadd

Oracle 10.2.0.3.0

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 1 2009

Added on Oct 30 2009

#performance-availability, #xml-db

6 comments

3,338 views