Home » Developer & Programmer » JDeveloper, Java & XML » Regarding schema validation and dbms_xmlparser, dbms_xmldom (9i)
Regarding schema validation and dbms_xmlparser, dbms_xmldom [message #572861] Tue, 18 December 2012 04:08
Messages: 4
Registered: April 2012
Location: Hyderabad
Junior Member
Hi All,

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"
('<?xml version="1.0"?>
).EXTRACT ('/employee/details')
) t;

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?


Previous Topic: Project Query
Next Topic: Extracting values from the XML string
Goto Forum:

Current Time: Thu Jul 29 05:24:52 CDT 2021