Concat XML data in a loop [message #669455] |
Mon, 23 April 2018 15:37 |
|
SoujanyaSM
Messages: 3 Registered: April 2018
|
Junior Member |
|
|
I ma new to XML, please help me!
I have to generate XML output from a PLSQL procedure. In my procedure I have a cursor which would call a function and get data something like below in every iteration.
<Employee>
<Name>Jonny</Name>
<Age>32</Age>
<Salary>$5000</Salary>
</Employee>
Now I have say a thousand employees. So I call the function 1000 times and I get XML response every time. I need to concatenate the data for 1000 employees and give as a response.
I tried using XML CONCAT function, but the function is not allowing me to use inside a loop.
Please help me here! thanks in advance!
-Soujanya
|
|
|