Cannot use XML functions in command window

[Roadling]

Cannot use XML functions in command window

SELECT XMLElement("Department",
d.fullname)
FROM departments d;

PLSQL Developer
XMLELEMENT("DEPARTMENT",D.FULL
------------------------------
Object

SQL PLUS
XMLELEMENT("DEPARTMENT",D.FULLNAME)
-----------------------------------
Airframe

PL/SQL Developer
Version 5.1.6.747 (MBCS)
Version 6.0.0.833 (MBCS)

Using
Home: ORANT
DLL: C:\ORANT\bin\oci.dll
OCI: version 9.2
Oracle9i Release 9.2.0.4.0
Character size: 1 byte(s)

 

[arbella_vng]

we are having the same problem
....

is it a version issue?

 

[Marco Kalter]

You will need to add the getclobvalue() function:

SELECT XMLElement("Department", d.fullname).getclobvalue()
FROM departments d;

The upcoming 6.0.4 releease will automatically get the XML text if you are using Oracle 9.2 or later.