Skip to Content
Aug 02, 2012 at 12:12 PM

How can we fetch xml data from database in MII


Hi All,

First of all I would like to thank all the members of this forum for their tremendous support provided so far. I am facing with one issue and need some help from you all. Here is my requirement

1) I am invoking an SQL procedure from MII which is written on SQL Server

2) This procedures returns one value (Out Parameter) which is in xml format

3) When I catch the value in MII I can see that all '>' chars are replaced with '>' in MII

4) I think MII returns the data in an xml format. So one xml data inside another one makes issue

Can anyone tell me how can I resolve this issue. I would like to assing the xml value which is returned by the procedure to another xml variable in MII.

I am using MII 12.1.9 version

Any help on this is very much appreciated