Constructing XML Dynamically
I have a C++ Application which needs to interface with multiple back end systems many of which support XML Interfaces. I currently use a third part C++ library which 'statically' converts the XSD into a C++ Class heirarchy which I bind into the Application. As a result every new interface needs development efforts which I need to eliminate.
As a result I am exploring other alternatives which have the following features:
-- Should be dynamic - no development efforts for new interfaces.
-- Should not be a freeware library - thats why i am preferring Oracle
The working product would recieve
-- A reference of the XSD to use
-- A parameter block of the values to go into the XML (I cannot have a corresponding database table from where the data can be picked up)
A PL/SQL Block should then be able to generate this XML block and return the result as a string to the application. I have explored certain alternatives
-- XMLElement - but building it dynamically is turning out to be painful.
-- XMLType View - extra overhead of registering a XSD always, plus its statically linked to a database schema table which is un-avoidable.
Has anybody used this type of a functionality and can provide me with some examples/pointers for the same? I am using a Oracle 10g database.