Oracle XML, Can I register a DTD?, Can I generate Tables from XML?

From: steve deno <sldcrew2k_at_yahoo.com>
Date: 26 Sep 2002 20:51:54 -0700
Message-ID: <8e6b14d8.0209261951.23e1020e_at_posting.google.com>

I just finished going through Oracles XML demo. It's really very cool. You can FTP schemas into the database, which generate object tables, then you can load xml docs into those tables and do all kinds of cool stuff. I have a couple questions on this.

First, I get an error:

ERROR at line 1:

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00247: invalid Document Type Declaration (DTD)

Error at line 4

ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 0
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 26
ORA-06512: at line 2

when I attempt to do the following(which I copied from the demo):

begin
dbms_xmlschema.registerSchema
('http://jtestdb1.healthetech.com:8080/home/SCOTT/xsd/ExampleDay3.dtd', xdbURIType('/home/SCOTT/xsd/ExampleDay3.dtd').getClob(), True,True,False,True
);

The DTD is valid as far as XML Spy is concearned, and has been used for some time. I was wondering if Oracle can register a DTD, or just a schema?

Also, Is there any functionality for creating a relational schema from XML?

ANY thoughts are GREATLY appreciated! Received on Fri Sep 27 2002 - 05:51:54 CEST