Hi All,
I got a requirement where I was asked to generate XML from an XSD and populate the data automatically.
I worked a lot on generating XMLS using XMLForest, XMLAGG function, XMLDOM packages. But in all those places I am using the table data and building my XML basing upon what is asked for. (IE. XSD). But now instead of this I was asked to generate XML Just by using XSD and provide the source information to generate XML.
It sounds strange as now the ask is that XML has to be generated with data automatically using the xsd. The reason behind this ask is suppose if an XSD changes then there should not be much change.
I was thinking of an approach on this one. If I register an XSD inside the database, it can create tables for the underlying XSD. Once the tables are created then I can create a process to load the data into those tables and then extract the XML from those tables.
Question for here here is I am just thinking about this approach and yet to try. I want to know whether automatic generation of XML Files using XSD is feasible in Oracle and if so whatever I have mentioned above is a feasible route or is there any other approach.
Much appreciate your help.
Thanks.