SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL*plus not displaying the result of XMLELEMENT

user7591510Feb 26 2010 — edited Feb 26 2010

HI,

I am using SQL*Plus: Release 10.1.0.4.2
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0

When I run the following query in SQL*PLUS, I get nothing displayed. However when I run the same query connecting to the same database using SQL Developer then I get the result

SQL> select XMLELEMENT("form_id",form_id)
2 FROM collections;

XMLELEMENT("FORM_ID",FORM_ID)
--------------------------------------------------------------------------------

In SQL developer

------------------------------------------------------------------------------------------------------------
<form_id>101</form_id>

I set long and longchuncksize to 32K , and I change linesize, pages, but nothing helped

Is there any configuration that I have to do, so that SQL*plus display the result of “ select XMLELEMENT("form_id",form_id) query.

Appreciate you help, thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2010

Added on Feb 26 2010

#sql, #sqlplus, #xml

6 comments

1,210 views