MQSeries.net :: View topic - Strange characters in XML tags extracted from Database...

moogoo

Hi,

I am totally stumped on a problem. What I am trying to do is to extract an XML clob from an Oracle database (v8.1.x) using the PASSTHRU command which calls a stored procedure and pass it to a repeating XML field in the OutputRoot. Standard stuff. What I then do is to use that XML clob and apply the "AsisElementContent" property to it to allow it to generate XML between the tags I specified in the OutputRoot. The XML clob as queried in Oracle shows that it should be well formed with no problems.

However, strange things are happening in the extracted XML clob as I view its contents in the trace file. Instead of getting for example:

<SourceTimeStamp>blah</SourceTimeStamp>

I am instead getting:

<Source TimeStamp>blah</SourceTimeStamp>

And that is not the only occurrence. It happens in other random tags as well (i've sent diff't types of data thru to test if there was a pattern in the positioning of this). I've gotten a "(" inserted in another tag and then what looks like a carriage return between two subsequent fields:

<Yadda>fdfs</Yadda>

<Curses>fdkj</Curses>

Now...all these problems do not exist while viewed in SQL Worksheet in Oracle...they all look fine. We are thinking there may be an ODBC driver problem but can't be certain.

Has anyone seen anything like this? What could be going on?

Any help would be GREATLY appreciated...

Thanks,

MG

PS - specs are WMQI v2.1 w/ CSD02 running on Solaris