Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using SYS_XMLGEN

Status
Not open for further replies.

olmos

Technical User
Oct 25, 2000
135
US

I am using Oracle's SYS_XMLGEN in a query. According to Oracle, it is supposed to always return a well-formed XML document.

My Query
-------------
SELECT SYS_XMLGEN(empno)
FROM emp WHERE ename LIKE 'SMITH%';

My Result is :
--------------
SYS_XMLGEN(EMPNO)

<EMPNO>7369</EMPNO>


I thought it was supposed to have the xml version on the first line. like this-
<?xml version=''1.0''?>
<empno>7369</empno>

Is there some setting I must change, what am I doing wrong?
How do I make it create a well formed xml document?

Thanks,
olmos

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top