Validating XML using table against XSD

please help in Validating XML file against XSD file using table structre attached with XSD  by PL/SQL
and display the error in case of non valid XML file
Note ( i have to XSD file reistered 1st file having the lobal types and 2nd file having the strucre )
 
Note 1. the XML file stored in physical file
        2. XSD's already registered.

malek_engAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
>>as i am not sure in the schema location i can reffer to the fisrt XSD

If I understand what you are wanting to do, when you registered the XSD you should have given it a URL.  You should be able to take that URL and use it for schemaLocation.

If you want to obtain them dynamically you can query all_xml_schemas.
0
 
malek_engAuthor Commented:
first of all i would to thank you very much about that solution, but here i heve different concept as the data Type in XSD file and the structre in other XSD  file and in attribute of the second one mintioning the XSD file having the type (such as <xs:import namespace="" schemaLocation="emp-glb.xsd"/> )
0
 
slightwv (䄆 Netminder) Commented:
You should be able to reference the registered URL of the first XSD in the second.
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
malek_engAuthor Commented:
Please Can you Provid me exampl
as i am not sure in the schema location i can reffer to the fisrt XSD
such as schemaLocation="Here i can put the URL"
Thank You

0
 
malek_engAuthor Commented:
No steps mintioned or example to follow
0
 
slightwv (䄆 Netminder) Commented:
Instead of a C grade and just closing this to get around the new question lock, you should have asked for additional information if you did not understand what I was telling you.
0
 
slightwv (䄆 Netminder) Commented:
I think the accepted answer, http:#a35728238 should be the correct solution.  I just don't think it should get a 'C'.

I'm willing to continue working on this if the asker needs further asssitance.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.