| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| [ODBC Oracle Wire Protocol driver]String data, right truncat |
« View previous topic :: View next topic » |
| Author |
Message
|
| jr_martin |
 Posted: Sun May 10, 2009 2:51 pm Post subject: [ODBC Oracle Wire Protocol driver]String data, right truncat |
 |
|
Apprentice
Joined: 24 Aug 2005
Posts: 36
Location: NY
|
Environment: WMB6103@solaris
Hi,
When I try to populate oracle(10.2.0.2) table from compute node, I get the exception - "[IBM][ODBC Oracle Wire Protocol driver]String data, right truncated. Error in parameter 3.". How to fix this issue?
--
(0x0100001B:Name+):MRM = ( ['mrm' : 0x10aeb7a60]
(0x01000013:Name+):project = (
(0x0300000B:NameValue+):C1 = '123' (CHARACTER)
(0x0300000B:NameValue+):C2 = 'ABC' (CHARACTER)
(0x0300000B:NameValue+):C3 = '35' (CHARACTER)
--
WHILE I <= J DO
INSERT INTO Database.SNPSSADM.TBLABC (C1,C2,C3)
VALUES(InputRoot.MRM.project[I].C1,
InputRoot.MRM.project[I].C2,
InputRoot.MRM.project[I].C3);
SET I = I + 1;
END WHILE; |
|
| Back to top |
|
 |
| jr_martin |
| Posted: Sun May 10, 2009 4:05 pm Post subject: |
|
|
Apprentice
Joined: 24 Aug 2005
Posts: 36
Location: NY
|
| Resolved. Just checked the tabel DDL. column size < insert field length. Corrected input msg to fix the issue. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
