OraFAQ Forum: JDeveloper, Java & XML » SQL / XML doesn't work here

Home » Developer & Programmer » JDeveloper, Java & XML » SQL / XML doesn't work here

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL / XML doesn't work here [message #150332]

Wed, 07 December 2005 06:57

romeog
Messages: 10
Registered: November 2005
Location: France

Junior Member

Hi,
I'm working on Oracle9i Enterprise Edition Release 9.2.0.5.0.
and with SQLPLUS i try this :

SELECT XMLFOREST(1 "test", 2 "test2") from dual;

But it seems taht it doesn't work I jsut have this result without error :

XMLFOREST(1"TEST",2"TEST2")
----------------------------------------------------------------

Has Someone an idea ?

thanks.

Romeo.

Report message to a moderator

Re: SQL / XML doesn't work here [message #150341 is a reply to message #150332]

Wed, 07 December 2005 08:01

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Try "SET LONG 100"

It works fine on my 9.2.0.5 box.

SQL> set long 1
SQL> SELECT XMLFOREST(1 "test", 2 "test2") from dual;

XMLFOREST(1"TEST",2"TEST2")
--------------------------------------------------------------------------------
<

SQL> set long 100
SQL> SELECT XMLFOREST(1 "test", 2 "test2") from dual;

XMLFOREST(1"TEST",2"TEST2")
--------------------------------------------------------------------------------
<test>1</test>
<test2>2</test2>


SQL>

MHE

Report message to a moderator