Sponsored Content
Full Discussion: Shell_scripts_xml_file
Top Forums Shell Programming and Scripting Shell_scripts_xml_file Post 302773471 by p.j.satyaveni on Thursday 28th of February 2013 03:09:44 AM
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
 
shell(1F)							   FMLI Commands							 shell(1F)

NAME
shell - run a command using shell SYNOPSIS
shell command [command] ... DESCRIPTION
The shell function concatenate its arguments, separating each by a space, and passes this string to the shell ($SHELL if set, otherwise /usr/bin/sh). EXAMPLES
Example 1: A sample output of shell command. Since the Form and Menu Language does not directly support background processing, the shell function can be used instead. `shell "build prog > /dev/null &"` If you want the user to continue to be able to interact with the application while the background job is running, the output of an exe- cutable run by shell in the background must be redirected: to a file if you want to save the output, or to /dev/null if you don't want to save it (or if there is no output), otherwise your application may appear to be hung until the background job finishes processing. shell can also be used to execute a command that has the same name as an FMLI built-in function. NOTES
The arguments to shell will be concatenate using spaces, which may or may not do what is expected. The variables set in local environments will not be expanded by the shell because "local" means "local to the current process." ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWcsu | +-----------------------------+-----------------------------+ SEE ALSO
sh(1), attributes(5) SunOS 5.10 5 Jul 1990 shell(1F)
All times are GMT -4. The time now is 04:54 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy