read xml to table

[spicysudhi]

hi

below is a sample xml data i have. i want to read this file and store it into a table using oracle procedure.

< Access>
< User email="test@domain.com" phone="+44 (0) 999 999 9999" first_name="fname" name="fname lname" last_name="lname">
< BasicSignon>loginA< / BasicSignon>
< Userclasses>
< Userclass name="Site User" />
< Userclass name="European Admin" />
< Userclass name="Sales Admin" />
< / Userclasses>
< / User >
< / Access>


i tried something similar to as in http://www.oracle-base.com/articles/...ocuments8i.php. However i didnot find a way to process the child nodes and also the attibutes of the nodes (like email, phone in User node).

if anyone got an example source, please help me. thanks in advance.

-sudhi