Instant Saxon (IE and text file)

[Micheal Geadah]

I am using oracle 8.1.7 database on windows2000 advanced server. I am using Instant saxon in order to transform XML documents into new XML documents. I am providing the Instant Saxon with the source XML document and XSL document. Its output in the IE6.0 is just fine like this:

<?xml version="1.0" encoding="utf-8" ?> 
<WRATE_INDICATORS>
<mappings>
  <RIND_CURR_CODE_1>119</RIND_CURR_CODE_1> 
  <RIND_CURR_CODE_2>131</RIND_CURR_CODE_2> 
  <RIND_INDICATOR>1</RIND_INDICATOR> 
</mappings>
<mappings>
  <RIND_CURR_CODE_1>119</RIND_CURR_CODE_1> 
  <RIND_CURR_CODE_2>136</RIND_CURR_CODE_2> 
  <RIND_INDICATOR>1</RIND_INDICATOR> 
</mappings>
</WRATE_INDICATORS>

But when i press view->source to see it in text file i get the following output:

<?xml version="1.0" encoding="utf-8"?>
<WRATE_INDICATORS>
  <mappings>
    <RIND_CURR_CODE_1>119</RIND_CURR_CODE_1>
    <RIND_CURR_CODE_2>131</RIND_CURR_CODE_2>
    <RIND_INDICATOR>1</RIND_INDICATOR>
  </mappings>
  <mappings>
    <RIND_CURR_CODE_1>119</RIND_CURR_CODE_1>
    <RIND_CURR_CODE_2>136</RIND_CURR_CODE_2>
    <RIND_INDICATOR>1</RIND_INDICATOR>
  </mappings>
</WRATE_INDICATORS>

Does the instant Saxon always do that??...Is there a way or maybe another processor in order to get the output in text file the same as IE6.0. Can i generate the file without the (encoding="utf-8") in the beginning of the file?
Thanks a lot...
EDIT: I put the XML into a CODE block in order to clean up the output a bit...
[ September 01, 2003: Message edited by: Lasse Koskela ]

[Lasse Koskela]

Oops. I just realized that the one-big-line-of-xml-elements was intentional, right (i.e. you were asking why Saxon produces the "ugly" output instead of nicely indented, human-readable output)?

[Lasse Koskela]

Try adding indent="yes" to your <xsl:output> element.

[Micheal Geadah]

Hi Lasse,
indent="yes" didn't work...
Is there another alternative???
Thanks...

[Lasse Koskela]

That's strange. I tried a simple transformation with indent="yes" with a number of parsers (MSXSL, Xalan, Saxon, Instant Saxon, XT) and all of them put the output on different lines. There was however differences in line indentation (i.e. how many characters to pad with, if at all).
Are you possibly using an old version of Instant Saxon?

[Micheal Geadah]

It worked there was a problem with the header...
Do u happen to know how to insert a DATE from an xml file into a table using XSU?
Thanks a lot...

[Lasse Koskela]

My answer would be "what is XSU"?
(I know it's Oracle's XML SQL Utility but only because I Googled for it...)
I would suggest asking the XSU question in our Oracle forum.