MQSeries.net :: View topic

sraman · Posted: Thu Jan 20, 2005 4:57 am Post subject:

We are using MQSIv2.1 with Oracle 8.1.7. Am getting error with the to_date function with PASSTHRU . Is there any compatibility issues ?

[MERANT][OD
BC Oracle 8 driver]String data, right truncated. Error in parameter 2.
____________________________________________________________

INSERT INTO APL_CUSTPROF.CUSTOMER (ID_NUMBER_SEQ,CREATE_DATE,CREATE_USER_ID,STATUS_CD,VER
IFICATION_CD,NAME, PHYSICAL_ADDR_LINE_1_TXT,PHYSICAL_ADDR_LINE_2_TXT,PHYSICAL_AD
DR_LINE_3_TXT,PHYSICAL_ADDR_CITY_NUMBER,PHYSICAL_ADDR_POSTAL_CD,MAILING_ADDR_LIN
E_1_TXT,MAILING_ADDR_LINE_2_TXT,MAILING_ADDR_LINE_3_TXT,MAILING_ADDR_CITY_NUMBER
, MAILING_ADDR_POSTAL_CD, INTNL_CALLING_CD,PHONE_AREA_CITY_CD,PHONE_NUMBER, PHYS
ICAL_ADDR_SEARCH_TXT,MAILING_ADDR_SEARCH_TXT,FAX_INTNL_CALLING_CD,FAX_AREA_CITY_
CD,FAX_NBR,SEGMENT_CD,SERVICE_LEVEL_CD,ORGANIZATION_NAME,ORGANIZATION_PROFILE_NB
R,PARENT_GROUP_NAME,PARENT_GROUP_NBR,CUSTOMER_GROUP_NBR,CUSTOMER_GROUP_NAME,GLOB
AL_ACCOUNT_CD)values (?,TO_DATE(?,'YYYYMMDDHH24MISS'),?,?,?,?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ) '661784', '20050119210207', 'CP_USER',
'A', 'N', 'JOHN'S SWEET SHOP', '', '', '', '5747', '94538', '', '', ''
, '5747', '94538', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '
', '3', 'JOHN'S SWEET SHOP', '480142', NULL, NULL, NULL, NULL, NULL, 2
321 Root SQL exception -1 2322 Child SQL exception 22001 0 [MERANT][OD
BC Oracle 8 driver]String data, right truncated. Error in parameter 2. '