Skip to Main Content

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!

XMLSerialize

493013Apr 25 2006 — edited Apr 25 2006
Hi,

I am trying to use the XMLSerialize example from Oracle documentation but it does not work:

SQL> select xmlserialize(content xmltype('<a>Grandco</a>')) from dual;

select xmlserialize(content xmltype('<a>Grandco</a>')) from dual
*
ERROR at line 1:
ORA-00907: missing right parenthesis

Any idea what might be wrong? The sqlplus is against a 9i db.

Thanks in advance...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 23 2006
Added on Apr 25 2006
2 comments
634 views