Developer hangs when using xmlelement

[Jacob Lundholm]

When executing the statement below in a SQL window the developer just hangs and must be killed from Windows task manager.

SELECT xmlelement("item_txt", item_txt)
FROM item;

By converting the XMLTYPE to a string data is returned as expected

SELECT xmlelement("item_txt", item_txt).getstringval()
FROM item;

The problem seems to be related with showing XMLTYPE data.

When executing the problematic statement in sqlplus I have no problem however.

Here is some data about my environment:

PL/SQL Developer
Version 7.0.0.1050 (MBCS)
01.31722 - 20 user license
Windows XP version 6,0 (build 2600) Service Pack 2

DLLs
c:\Oracle9i\bin\oci.dll

Using
Home: Oracle9i
DLL: c:\Oracle9i\bin\oci.dll
OCI: version 9.2
Personal Oracle9i Release 9.2.0.1.0
Character size: 1 byte(s)

 

[Marco Kalter]

There are some unfortunate bugs in the Oracle Client regarding the SYS.XMLTYPE class. If all is well these issues will be resolved in Oracle11. In the mean time you should use getstringval() or getclobval() to prevent client-side XMLTYPE instances.