This content has been marked as final. Show 2 replies
Is there a way of getting element names and attributes from a registered Schema in 10gR2.Sure, the same way you would query any other XML document. What did you try?
As the XSD changes I want to do this dynamically based on the schemalocation.That would mean build the query as a string and run it via dynamic SQL. Not a good idea.
If the schema evolves then change the query accordingly.
If the schema evolves then the target table has to evolve too right?
Are you planning on doing that dynamically too?
Please explain exactly what you want through an example.
Such simplicity. Hadn't even thought of that.
Good point - I see what you are saying that the inserts need updated as well.