Hi,
I mapped a table in Oracle database into a Tamino schema. The table schema is here:
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER(5)
CV_ORG_LOCATION VARCHAR2(250)
CV_ORG_NAME VARCHAR2(100)
CV_NEW_LOCATION VARCHAR2(250)
CV_NEW_NAME VARCHAR2(100)
CV_DATE NUMBER(8)
===============================================
After I successfully mapped the table into Tamino schema, I tried to query the data records through Interactive Interface. Unfortunately, an error occurred when returning the query result. The error is here:
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.
--------------------------------------------------------------------------------
A name contained an invalid character. Error processing resource ‘http://localhost/tamino/resume_db/oracle_collection’. Line 1, Position 324
<?xml version="1.0" encoding="big5" ?><ino:response xmlns:ino=“http://namespaces.softwareag.com/tamino/response2” xmlns:xql=“http://metalab.unc.edu/xql/”>xql:query/CANDIDATEt%CV[ID=84]</xql:query><ino:message ino:returnvalue=“0”>ino:messagelineXQL Request processing</ino:messageline></ino:message>xql:result<CANDIDATEt%CV>84<CVt%ORGt%LOCATION></CVt%ORGt%LOCATION><CVt%ORGt%NAME></CVt%ORGt%NAME><CVt%DATE>20020301</CVt%DATE></CANDIDATEt%CV><CANDIDATEt%CV>84<CVt%ORGt%LOCATION></CVt%ORGt%LOCATION><CVt%ORGt%NAME></CVt%ORGt%NAME><CVt%DATE>20020301</CVt%DATE></CANDIDATEt%CV></xql:result><ino:cursor ino:count=“2” ><ino:first ino:href=“?t%XQL(1,16)=/CANDIDATEt%CV[ID=84]” /></ino:cursor><ino:message ino:returnvalue=“0”>ino:messagelineXQL Request processed</ino:messageline></ino:message></ino:response>
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------^
================================================
However, when I tried to query data through X-Plorer, no such error occurred.
Can anyone tell me why? Thanks!
Andy