DB: 12.1.0.2 (Not RAC)
OS: Linux, kernal 2.6.32
My database has a table with a CLOB column. Each row contains one XML document within that CLOB column. Below is an example of a very small document:
<?xml version="1.0"?>
<DOCUMENT structured-text="generic-5.0" VERSION="A">
<DOC_ID SEQUENCE="DOC_ID"/>
<DOC_DLU EXPRESSION="SYSDATE"/>
<DOC_DTG>20110525</DOC_DTG>
<DOC_OFFICE_LOCATION>Boston</DOC_OFFICE_LOCATION>
<BODY>
<GEN_SUBJECT>
<DOCNAME>K5TTY5989J</DOCNAME>
<GEN_SUBJECT>
<FIRSTNAME>Sizzley</FIRSTNAME>
<SURNAME>Costello</SURNAME>
<DOB>19440606</DOB>
<DOCNAME>K5TTY5989J</DOCNAME>
</GEN_SUBJECT>
</GEN_SUBJECT>
</BODY>
</DOCUMENT>
Is there an Oracle function in which I could pass a series of these records and the function would generate a DTD for the set of documents?
Any hints or ideas greatly appreciated.