Shell_scripts_xml_file Post: 302773471

Sponsored Content

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

02-28-2013

Registered User

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

p.j.satyaveni

View Public Profile for p.j.satyaveni

Find all posts by p.j.satyaveni

LEARN ABOUT PHP

mssql_free_result

MSSQL_FREE_RESULT(3)													      MSSQL_FREE_RESULT(3)

mssql_free_result - Free result memory

SYNOPSIS

       bool mssql_free_result (resource  $result)

DESCRIPTION

       mssql_free_result(3) only needs to be called if you are worried about using too much memory while your script is running. All result memory
       will automatically be freed when the script ends. You may call mssql_free_result(3) with the result identifier as an argument and the asso-
       ciated result memory will be freed.

PARAMETERS

	      o $result
		- The result resource that is being freed. This result comes from a call to mssql_query(3).

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      mssql_free_result(3) example

	      <?php
	      // Select some data from a table
	      $query = mssql_query('SELECT * FROM [php].[dbo].[persons]', $link);

	      // Handle query result here

	      // When we're done we free the result by calling
	      // mssql_free_result like so:
	      mssql_free_result($query);
	      ?>

SEE ALSO

       mssql_free_statement(3).

PHP Documentation Group 												      MSSQL_FREE_RESULT(3)