MQSeries.net :: View topic - DBerror- datatype for param hs changd since 1st sql exec cal

jbanoop

Hi All,
We are getting a problem with database insertion.
WBIMB V 6.0.0 (toolkit and broker)
oracle 9.0.2
WinXP service pack 2

the following code is there at two places, in two different DB nodes with same DSN name and transaction mode set to commit. (these are basically code for tracking points to identify till where the flow has executed). The flow is of the form MQInput ->DB node (first node) ->compute ->MQ Output ->MQ get ->DB node (2nd node) ->compute ->Mq Output

in first node:
--------------
DECLARE BlobData4 BLOB BITSTREAM(Root.XML);
Insert Into Database.SR_MNP_LINE_AUDIT_TBL (LINE_ID, SR_ID, TIMESTAMP,MSISDN, TRACKING_POINT, MESSAGE)
VALUES (Environment.Variables.LINE_ID.NEXTVAL,
TRIM(Environment.Variables.MNP.SRID),
CURRENT_TIMESTAMP,
Environment.Variables.MSISDN,
567,
SUBSTRING(CAST(BlobData4 AS CHAR CCSID 1208) FROM 1 FOR 4000)
);

In second node:
-------------------

DECLARE BlobData5 BLOB BITSTREAM(Root.XML);
Insert Into Database.SR_MNP_LINE_AUDIT_TBL (LINE_ID, SR_ID, TIMESTAMP,MSISDN, TRACKING_POINT, MESSAGE)
VALUES (Environment.Variables.LINE_ID.NEXTVAL,
TRIM(Environment.Variables.MNP.SRID),
CURRENT_TIMESTAMP,
Environment.Variables.MSISDN,
568,
SUBSTRING(CAST(BlobData5 AS CHAR CCSID 1208) FROM 1 FOR 4000)
);

its giving the error saying
datatype for param 6 has changd since 1st sql exec call , while executing in the query in the second node.
The content of Root.XML obviously changes (db node 1 is input xml and db node 2 is output xml recvd from MQ Get node).

Any suggestions on this would be greatly appriciated.

Regards,
Anoop