Bug with XMLAGG()

[ILay]

PSD 7.1.3.1381
Just try to execute simple query in SQL Window.

select xmlagg(xmlforest(dummy)) xml from dual;

Window hangs, so I can only close it and choose terminate in dialog (button Break doesn't work).

 

[Marco Kalter]

Works fine for me. What is your Oracle Client and Server version?

 

[ILay]

OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.8.0

 

[Relogin]

Yes! This is severe bug.

select xmlelement("1111", dummy) from dual
and ... application hangup...
ORACLE 9.2 Client and Server.

Allround Automation not working with XMl on Oracle?

 

[Marco Kalter]

It's probably a 9.2 client issue. Can you upgrade to a 10g or 11g client and try again? The XMLTYPE implementation on older client versions is not really robust.

 

[Relogin]

I confirm - the problem has disappeared after installation Oracle Client 10g
Thank you.