0 Replies Latest reply on Aug 15, 2019 8:58 PM by Paul V.

    Generate DTD from XML

    Paul V.

      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.