Inserting xml data into an XMLTYPE table

<XxxsSum>
<xxxSum>

        <A>...</A><B>...</B>...
</xxxSum>
<xxxSum>

        <A>...</A><B>...</B>...
</xxxSum>

...
</xxxsSum>

I have defined an XML_FILES directory and created a table (create table mytable of xmltype; ).

If I use a statement like

        Insert into <mytable> values (xmltype(bfilename('XML_FILES','myfile.xml', nls_charset_id('AL32UTF8')));

it goes in as a single row. How can I load this into a table so that each of the <xxxSum>...</xxxSum> blocks is in a separate row?

Thanks,
Peter Schauss

--
http://www.freelists.org/webpage/oracle-l