How can we fetch xml data from database in MII

[shaji_chandran]

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

Thanks

Shaji

[Former Member]

I would almost question why you are returning xml from the stored proc. Might be easier to return just the single value as is or in a table if the need for multi values might arrise. That way Mii returns the value(s) right away in the Mii xml format.

[Former Member]

Hi Shaji

its will  be simpler for you to return  the sproc in a table   and  call  that with SQL template  that will  save you whole lots of time.

you can use the transformation block  to get you required block

hope this helps

[former_member185280]

Try using the xmldecode function in the link editor.