|Regarding schema validation and dbms_xmlparser, dbms_xmldom [message #572861]
||Tue, 18 December 2012 04:08
Registered: April 2012
Recently I came across one scenario, where I need to register XSD and validate all incoming xml agaist registered XSD and then access its contents and process them as per business needs.
To accomplish this:
1. Simply I have registered XSD using registerschema .
2. To validate xmls, used schemaValidate .
3. Once this is done then to fetch value from xml, I used below statement:
SELECT EXTRACTVALUE (COLUMN_VALUE, '/details/emp_id') "Employee_ID"
This works fine.
But I was browsing the same requirement over forum, got solutions related to DBMS_XMLPARSER and DBMS_XMLDOM.
I tried to go through its details but didnt get much idea on the same.
Can anyone please help me to understand about use of dbms_xmlparser and dbms_xmldom and about DOM.
In which scenario we need to use them?