| Author |
Message |
 Topic: How to Decode the Xml value from the Blob filed |
Laaziya
Replies: 20
Views: 10012
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Mar 13, 2014 5:22 am Subject: How to Decode the Xml value from the Blob filed |
x03000000:NameValue):Text = 'Error detected, rethrowing' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
... |
| Topic: How to Decode the Xml value from the Blob filed |
Laaziya
Replies: 20
Views: 10012
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Mar 13, 2014 4:20 am Subject: How to Decode the Xml value from the Blob filed |
It doesn't work. I tried out to change the flow too . Did work  |
| Topic: How to Decode the Xml value from the Blob filed |
Laaziya
Replies: 20
Views: 10012
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Mar 13, 2014 1:50 am Subject: How to Decode the Xml value from the Blob filed |
SET Environment.Outbound.claim= PASSTHRU('SELECT XML_IN FROM CLAIM_XML WHERE CLM_RECRD_ID =?',Id);
DECLARE bodyBlob BLOB ASBITSTREAM(InputRoot.XMLNS, InputProperties.Encoding,InputProperties.Coded ... |
| Topic: How to Decode the Xml value from the Blob filed |
Laaziya
Replies: 20
Views: 10012
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Mar 13, 2014 1:20 am Subject: How to Decode the Xml value from the Blob filed |
| Yes im try to parse the XML from table to XLMNSC using the above code. but it leads error. |
| Topic: How to Decode the Xml value from the Blob filed |
Laaziya
Replies: 20
Views: 10012
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Mar 13, 2014 12:51 am Subject: How to Decode the Xml value from the Blob filed |
I have used the below code..It results with an Error while debugging .
DECLARE wholeMsgBlob BLOB ASBITSTREAM(InputRoot.XMLNSC,InputRoot.Properties.Encoding,InputRoot.Properties.CodedCharSetId );
... |
| Topic: How to Decode the Xml value from the Blob filed |
Laaziya
Replies: 20
Views: 10012
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 12, 2014 11:51 pm Subject: How to Decode the Xml value from the Blob filed |
Yes u r right. in one flow they are encoding it and inserting in CLOB(Datatype) and inserting it. Another flow we need to fetch ahd reuse it.
Is ter is any way To insert xml to CLOB(datatype) with ... |
| Topic: How to Decode the Xml value from the Blob filed |
Laaziya
Replies: 20
Views: 10012
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 12, 2014 11:41 pm Subject: How to Decode the Xml value from the Blob filed |
| Or Is there is any other way to insert the XML in CLOB(datatype) in table , So tat we insert directly and fetch the XML to use it... |
| Topic: How to Decode the Xml value from the Blob filed |
Laaziya
Replies: 20
Views: 10012
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 12, 2014 11:38 pm Subject: How to Decode the Xml value from the Blob filed |
Thanks, I will let you know in detail,
We have done below one to encode the values so that it would be inserted in CLOB(datatype)in table. It worked fine and xml got inserted.
DECLARE wholeMsg ... |
| Topic: How to Decode the Xml value from the Blob filed |
Laaziya
Replies: 20
Views: 10012
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 12, 2014 10:11 pm Subject: How to Decode the Xml value from the Blob filed |
I have tried below one
DECLARE wholeMsgBlob BLOB ASBITSTREAM(InputRoot.XMLNSC,InputRoot.Properties.Encoding,InputRoot.Properties.CodedCharSetId );
DECLARE wholeMsgChar CHAR CAST(wholeMsgBlob AS C ... |
| Topic: How to Decode the Xml value from the Blob filed |
Laaziya
Replies: 20
Views: 10012
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 12, 2014 9:59 pm Subject: How to Decode the Xml value from the Blob filed |
| I could not get the code. Can you pls let me know What exactly must be done |
| Topic: Need to replace some value in XML |
Laaziya
Replies: 5
Views: 5613
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 11, 2014 6:03 am Subject: Need to replace some value in XML |
Hi every one,
I have inserted an Xml in CLOB field. I need to retrive those Xml and I need to replace with some values (these values are fetched from the Table) to the Xml.
Eg:
<4000A>
... |
| Topic: How to Decode the Xml value from the Blob filed |
Laaziya
Replies: 20
Views: 10012
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Mar 10, 2014 11:41 pm Subject: How to Decode the Xml value from the Blob filed |
Hi Everyone,
We have encoded to insert the xml to a Blob field.
DECLARE wholeMsgBlob BLOB ASBITSTREAM(InputRoot.XMLNSC,InputRoot.Properties.Encoding,InputRoot.Properties.CodedCharSetId );
DE ... |
| Topic: To Insert Xml into Blob field in oracle DB via esql |
Laaziya
Replies: 1
Views: 2776
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Mar 06, 2014 5:55 am Subject: To Insert Xml into Blob field in oracle DB via esql |
Hi Everyone,
I need to insert the XML into blob field in oracle db. Tried below query, it is resulting with invalid hexadecimal conversion. Can any one help us through...
DECLARE wholeMsgBlob ... |
