Shell_scripts_xml_file

Shell Programming and Scripting
1

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

if i use otherathan .xml file (like csv etc) i got the result, but for only .xml file i didnt got the data.
and the query inside script is

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

this query is working fine but in shell script only it is not generated any output.
Please help me to solve this issue.

2

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??