| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Trouble inserting Special Characters in Oracle using WBIMB |
« View previous topic :: View next topic » |
| Author |
Message
|
| jeasterl |
 Posted: Wed Oct 13, 2004 1:29 pm Post subject: Trouble inserting Special Characters in Oracle using WBIMB |
 |
|
Acolyte
Joined: 24 Jun 2001
Posts: 65
|
All,
I am having difficulty inserting special characters into an Oracle database using WebSphere Business Integration Message Broker Version 5.0, CSD04. The platform is Solaris 8.
The error message refers to '[DataDirect][ODBC Oracle driver]String data, right truncated. Error in parameter 6.' on insert into table ALT_AIRPORT. Parameter 6 is column DEP_STATION_ALT. In the following extract we can see the parameter values and that column 6 is the first column with control characters :
INSERT INTO ALT_AIRPORT (FLT_NUMBER, FOS_PARTITION_CODE,
FLT_ORIGIN_DATE, DEP_STATION, LEG_SEQ_NUM, DEP_STATION_ALT,
ARR_STATION_ALT1, ARR_STATION_ALT2, ENROUTE_STATION_ALT1,
ENROUTE_STATION_ALT2, ENROUTE_STATION_ALT3, ENROUTE_STATION_ALT4,
ENROUTE_STATION_ALT5, ENROUTE_STATION_ALT6, ENROUTE_STATION_ALT7,
ENROUTE_STATION_ALT8, ENROUTE_STATION_ALT9, ENROUTE_STATION_ALT10,
ENROUTE_STATION_ALT11, ENROUTE_STATION_ALT12, ENROUTE_STATION_ALT13,
ENROUTE_STATION_ALT14, ENROUTE_STATION_ALT15) VALUES ('0045', 'AA',
TIMESTAMP '2004-07-14 00:00:00', 'NRT', '0', 'A~ , '?|<', '>\\',
' , '?@'', ' , '? 204', ' 206 , '? ', ' &', '&&%',
'1'!', '#^*', '( , ' , '? ', ' , '? ')
The DEP_STATION_ALT is defined as CHAR(3). This INSERT statement works from a command line (SQLPlus).
Any help would be appriciated! |
|
| Back to top |
|
 |
| RocknRambo |
| Posted: Wed Oct 13, 2004 5:21 pm Post subject: |
|
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
| Did u try using the PASSTHRU statement...??? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Oct 13, 2004 5:56 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Remember that within the ESQL operating environment, that everything is Unicode... so what you think is a control character might be something else in your oracle native charset.
_________________
I am *not* the model of the modern major general. |
|
| 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
|
|
|
|
