Bug Related to XML

[Radoslav Rusinov]

This message is for support team.
We are customers of PL/SQL Developer and we have found the following bug when we are using XML.
When the following SQL is executed on out server it return the result grid but do not stop executing. Executing take an infininite time and cannot be stopped.
select XMLElement("XML",
XMLAttributes(t.column_1 as VERSION,
t.column_2 as ENCODING),
XMLElement("COLUMN_3", t.column_3)) XML
from our_table t

When the same code is executed via SQL*Plus it is executed successfully and without any problems.
If the officially registration of bugs cannot be done by using this forum can explain me how to do it. Because we need that this SELECT to work normally as well.
Thanks in advance!

Best Regards,
Radoslav Rusinov

 

[Marco Kalter]

This is most likely an Oracle Net bug. You can use the GetClobVal() to circumvent this:

select XMLElement("XML",
XMLAttributes(t.column_1 as VERSION,
t.column_2 as ENCODING),
XMLElement("COLUMN_3", t.column_3)).GetClobVal() XML
from our_table t