Hi develope one shell in that i use sql query.
i want to display that query output in .xmlfile
after running the script output file is generated but it doesnt diplays data and throws an error.following is the output of the .xml file

XMLELEMENT("ALL",XMLAGG(XMLELEMENT("DATABASE_OBJECTS",XMLFOREST(OWNER,OBJECT_TYP
<All><DATABASE_OBJECTS><OWNER>APPS</OWNER><OBJECT_TYPE>FUNCTION</OBJECT_TYPE><
OB

select 
xmlelement("All", 
xmlagg(
XMLELEMENT ("DATABASE_OBJECTS",
XMLFOREST (owner,
object_type,
object_name,
object_user_name,
physical_name
))
)
).getClobVal()
FROM xxhex_custom_objects;

So you output is OK when you are saving that to a csv or a text file? and it throws an error only when you attempt to save in xml file?

Why don't u try saving the output in a TEMP file and rename it to file.xml??