"Binny" <Binny@d...> wrote in message 
news:70BC4258-7CD7-4269-BC1F-F67F5F30E21A@m......
> 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
>
Aside from the fact that xml with this structure is going to be a nightmare to 
process it shouldn't be too difficult. What exactly do you have to start with 
and in what environment are you processing?

-- 

Joe (MVP - XML)

https://mvp.support.microsoft.com/profile=8AA9D5F5-E1C2-44C7-BCE8-8741D22D17A5