Hello,
We have a requirement to generate XML that confirms to a schema. This XML should contain data that is present in DB tables. Number of XMLs that are generated is huge and then they are send through
java code to message queues.
Recently Oracle 10g has a feature of generating XMLs on the fly at DB level using its XMLParse functions and return XML.
My question is that from architectural perspective is it a good approach to generate too many XMLs at DB level.
Yes / no what are the reasons.