Shell_scripts_xml_file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Shell_scripts_xml_file
Prev   Next
# 1  
Old 02-28-2013
Shell_scripts_xml_file

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
Code:
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
Code:
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.

Last edited by Franklin52; 02-28-2013 at 05:39 AM.. Reason: Please use code tags for data and code samples
 
Login or Register to Ask a Question

Previous Thread | Next Thread
Login or Register to Ask a Question