Here is another example where it goes wrong. I have a query with a subquery to get devices and their pins. I have stripped the query down to make to its core:
select
xmlelement (name device,
XMLATTRIBUTES(e.ID),
XMLELEMENT( NAME "pins",
(select XMLAGG(XMLELEMENT( NAME "pin",
XMLATTRIBUTES(t.label),
))
from SSED_TERMINATION t
)))
from SSED_EQUIPMENT e
If I view the results in the web browser mode in preview I get the results I expect except the device element is in a black font (indicating that it is text and not xml). In the text view it looks like this:
I am having hard time to reproduce the same behavior.
By any chance one of the columns you are working with contains XML or is defined as XMLType?
If that is case, Coould you try with the latest Stylus Studio version (6.3)?
Thank You
Ivan Pedruzzi
Stylus Studio
>
>Here is another example where
>it goes wrong. I have a query
>with a subquery to get devices
>and their pins. I have
>stripped the query down to
>make to its core:
>
>select
> xmlelement (name device,
> XMLATTRIBUTES(e.ID),
> XMLELEMENT( NAME "pins",
>(select XMLAGG(XMLELEMENT(
>NAME "pin",
> XMLATTRIBUTES(t.label),
> ))
> from SSED_TERMINATION t
> )))
>
>from SSED_EQUIPMENT e
>
>If I view the results in the
>web browser mode in preview I
>get the results I expect
>except the device element is
>in a black font (indicating
>that it is text and not xml).
>In the text view it looks like
>this:
>
><?xml version="1.0"
>encoding="UTF-8" ?>
><root>
> <row>
><Column-1><DEVICE
>ID="18711"&a
>mp;gt;<pins>&
>;lt;pin
>LABEL="A"&am
>p;gt;</pin>&
>lt;pin
>LABEL="B"&am
>p;gt;</pin>&
>lt;/pins></DEVIC
>E></Column-1>
> </row>
></root>
>
>
>
>