Oracle Database Discussions

Hey,

I have an XML file stored in an Oracle 10g database as a BLOB. I was wondering if anyone knew how to use extract to get the values out of the file. I just want to get group name and every user in the group. I have included a copy of the XML file below for your review. I have tried to extract XML from it in the past but it seems the metadata: (colon) messes something up. Any help would be much appreciated.

Thank you!

Jeffrey Kevin Pry

<metadata:Group xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<id>20</id>
<groupName>Users</groupName>
<nameSpace>Domain</nameSpace>
<description></description>
<userRef xsi:type="metadata:UserRef" objVersion="1.1.19">
<userName>user1</userName>
<nameSpace>Domain</nameSpace>
</userRef>
<userRef xsi:type="metadata:UserRef" objVersion="1.1.19">
<userName>user2</userName>
<nameSpace>Domain</nameSpace>
</userRef>
</metadata:Group>

Edited by: user12044013 on Apr 15, 2010 10:12 AM