XML type in sql window

[yann]

Good afternoon,

When I try to execute a query using XMLELEMENT function in an sql window, PL/SQL developer never give me back the result.
It stay in execution mode, with the hourglass, without giving any result.

I tried with really simple query like
SELECT XMLELEMENT ("Test" , 'X')
FROM DUAL

Best regards

 

[Marco Kalter]

Some Oracle client versions have problems with the XMLTYPE class. To work around the problem, use the GetClobVal() member function:

SELECT XMLELEMENT ("Test" , 'X').GetClobVal()
FROM DUAL

 

[yann]

Good morning,

This is working fine...thank you.