Hi Folks,

We are currently writting generic PL/SQL APIs to generate XML based on the 
data in the tables.

We have the following requirements:

    * Let us say a table consists of two columns namely "ProductName" 
"ProductValue".
    * Now I have to generate XML in the following way:
          o <ProductName>ProductValue<ProductValue>
    * So what we are saying is that the Node's name in the XML is dynamic.
    * For example if the table consisted of the following values

Product Name      Product Value
----------------------------------
A                             100
B                             200
C                             300


We want the XML as

<A>100</A>
<B>200</B>
<C>300</C>


Primarily we want to understand a way to create XML where the NAMES OF THE 
NODES themsleves are known only at run-time.

I understand that this a wierdo requirement :-) ........but well....lets 
just say I have no other option... :-) ..

We tried SQLX and XMLGen but were'nt very successful.

Appreciate any help in this requirement.



Regards