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...
See fragments