Subject: [xsl] WHITESPACE WITHIN TAGS. From: "michel geadah" <m_ace_g@xxxxxxxxxxx> Date: Thu, 04 Sep 2003 08:05:00 +0000 |
hello, I am using oracle 8.1.7 database on windows2000 advanced server and XSU package. When i generate an xml file from the database tables, i get an error message on the internet explorer: "A name contained an invalid character. Error Processing Resource". The problem is that some of the tags are cut into two and the second goes to a new line when the xml file is generated. If i open the file in notepad and readjust the tags to become one on the same line then the xml file is loaded correctly... This is the output of the generated XML on IE6.0.
The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
Whitespace is not allowed at this location. Error processing resource 'file:///Z:/ora81/bin/EMPS.xml'. Line 36, Position 8
when I open the file in Notepad to view the source i get this See fragments in records 4 & 8)
<?xml version = '1.0'?> <EMPS> <mappings Record="1"> <EMPNO>1000</EMPNO> <ENAME>KING</ENAME> <JOB>salesman</JOB> <MGR>1001</MGR> <SAL>2001</SAL> <DEPTNO>10</DEPTNO> <DOUBLE_SAL>3500</DOUBLE_SAL> <PICTURE>333.tif</PICTURE> </mappings> <mappings Record="2"> <EMPNO>1001</EMPNO> <ENAME>CHARBEL</ENAME> <JOB>manager</JOB> <SAL>5000</SAL> <DEPTNO>10</DEPTNO> <DOUBLE_SAL>7000</DOUBLE_SAL> <PICTURE>ccc.jpg</PICTURE> </mappings> <mappings Record="3"> <EMPNO>1002</EMPNO> <ENAME>GEORGES</ENAME> <JOB>salesman</JOB> <MGR>1001</MGR> <SAL>2500</SAL> <DEPTNO>11</DEPTNO> <DOUBLE_SAL>4000</DOUBLE_SAL> <PICTURE>image8.tif</PICTURE> </mappings> <mappings Record="4"> <EMPNO>1003</EMPNO> <ENAME>MICHEL</ENAME> <JOB>manager</JOB> < SAL>3500</SAL> <DEPTNO>12</DEPTNO> <DOUBLE_SAL>5000</DOUBLE_SAL> <PICTURE>111.TIF</PICTURE> </mappings> <mappings Record="5"> <EMPNO>1004</EMPNO> <ENAME>JEAN</ENAME> <JOB>security</JOB> <MGR>1003</MGR> <SAL>1750</SAL> <DEPTNO>13</DEPTNO> <DOUBLE_SAL>4000</DOUBLE_SAL> <PICTURE>bmw.jpg</PICTURE> </mappings> <mappings Record="6"> <EMPNO>1005</EMPNO> <ENAME>RUDI</ENAME> <JOB>secretary</JOB> <MGR>1003</MGR> <SAL>2750</SAL> <DEPTNO>13</DEPTNO> <DOUBLE_SAL>4000</DOUBLE_SAL> <PICTURE>image3.tif</PICTURE> </mappings> <mappings Record="7"> <EMPNO>1020</EMPNO> <ENAME>GERARD</ENAME> <JOB>salesman</JOB> <SAL>3200</SAL> <DEPTNO>10</DEPTNO> <PICTURE>image2.tif</PICTURE> </mappings> <mappings Reco rd="8"> <EMPNO>2343</EMPNO> <ENAME>enhyg</ENAME> <SAL>1111</SAL> <DEPTNO>13</DEPTNO> <PICTURE>image1.tif</PICTURE> </mappings> <mappings Record="9"> <EMPNO>1022</EMPNO> <ENAME>zico</ENAME> <JOB>salesman</JOB> <MGR>1000</MGR> <HIREDATE>1/21/2001 0:0:0</HIREDATE> <SAL>3200</SAL> <COMM>1223</COMM> <DEPTNO>13</DEPTNO> <PICTURE>no_image.tif</PICTURE> </mappings> <mappings Record="10"> <EMPNO>1009</EMPNO> <ENAME>CHICH</ENAME> <SAL>4500</SAL> <DEPTNO>13</DEPTNO> <PICTURE>image.tif</PICTURE> </mappings> <mappings Record="11"> <EMPNO>4532</EMPNO> <ENAME>FEFFR</ENAME> <JOB>RRR</JOB> <MGR>43</MGR> <SAL>3535</SAL> <COMM>14</COMM> <DEPTNO>14</DEPTNO> </mappings> </EMPS>
when i fix the fragments in records 4 and 8 and refresh the page the output is displayed correctly... Besides i am using XML SQL utility (XSU) to generate an XML document from inside of the Oracle environment... Does anyone know the solution? Thanks for your help...
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Size limit for input file, Dipesh Khakhkhar | Thread | RE: [xsl] WHITESPACE WITHIN TAGS., Michael Kay |
RE: RE: [xsl] HTML Table, Jarno . Elovirta | Date | [xsl] setting and returning variabl, M. David Peterson |
Month |