Hi,
i am using PLSQL Version 6.0.6.947
and i am using XMLTYPE all the time (so i need this bug to be fixed !)
if i am trying to run this query,
the session hung, i am not getting my results, and i cannot stop the session.
the query -
SELECT XMLELEMENT("MY_ROOT",
xmlattributes ('Attr1_value' AS Attr1),
XMLFOREST ( 'Child1_value' AS Child1
)) xml
FROM dual;
pay attention, that if i add ".getstringval()" at the end (so the results will be string and not xmltype), it is ok, and i am getting my results.
so the problem is showing an XMLTYPE results.
Thanks,
Shay
i am using PLSQL Version 6.0.6.947
and i am using XMLTYPE all the time (so i need this bug to be fixed !)
if i am trying to run this query,
the session hung, i am not getting my results, and i cannot stop the session.
the query -
SELECT XMLELEMENT("MY_ROOT",
xmlattributes ('Attr1_value' AS Attr1),
XMLFOREST ( 'Child1_value' AS Child1
)) xml
FROM dual;
pay attention, that if i add ".getstringval()" at the end (so the results will be string and not xmltype), it is ok, and i am getting my results.
so the problem is showing an XMLTYPE results.
Thanks,
Shay