MQSeries.net :: View topic

satnam · Posted: Wed Dec 31, 2003 7:16 am Post subject:

I am trying to Save XML data as CLOB in Database and later trying to retrieve CLOB and convert it back to XML

I am able to Save the XML as CLOb successfully using following Code

SAVE THE MESSAGE using
=================
DECLARE bContent BLOB;
SET bContent = ASBITSTREAM("Body") ;

INSERT INTO Database.TABLEX(
RECORDTYPE,SOURCERECORDID , XMLDATA)
VALUES (Type, RecordId, bContent);

Later I am trying to retrieve the information back from database and convert back to XML

Get the Message using
==============
SET Environment.TMP.MyData = THE (SELECT ITEM M.XMLDATA FROM Database.ISESUSPENSE AS M WHERE M.RECORDTYPE = Type
AND M.SOURCERECORDID = RecordId);

CREATE FIRSTCHILD OF Environment.TMP.TRAN Domain('XML') PARSE(Environment.TMP.MyData);

SET OutputRoot.XML = Environment.TMP.TRAN.XML;

SET Environment.TMP = NULL;

But I get the following error in the trace

An attempt was made to cast the character string
'<?xml version="1.0" encoding="UTF-8"?><CUSTOMER><OFFICE>123</OFFICE></CUSTOMER>' to a byte string,
but the string was of the wrong format. There must be an even number of hexadecimal digits (0-9, a-f, A-F).

Please advise

Thanks