Database Software

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!

XMLElement() returns 'XMLTYPE()'

aticsayMar 22 2007 — edited Mar 23 2007

Hi. I'm a newbie to Oracle XML, and I'm having trouble just getting off the ground. I would expect the following SQL statement:

select xmlelement("dummy",dummy) result from dual;

to return

RESULT
----------------
<dummy>X</dummy>

but instead it returns

RESULT()
---------
XMLTYPE()

Any idea why?

I'm running Oracle Database version 10.2.0.2.0 and SQL*Plus version 9.0.1.4.0.

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 20 2007

Added on Mar 22 2007

#performance-availability, #xml-db

2 comments

782 views