| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| insert date into ORACLE DATABASE[URGENT] |
« View previous topic :: View next topic » |
| Author |
Message
|
| nicojvr |
 Posted: Fri Oct 24, 2003 2:42 am Post subject: insert date into ORACLE DATABASE[URGENT] |
 |
|
Apprentice
Joined: 04 Jun 2003
Posts: 45
|
Hi guys, i am having alot of trouble performing an insert into the database :
| Code: |
passthru('insert into mds_mq_audits
columns (AUDIT_CODE,
MQSSER_SOURCE_SERVICE_CODE,
MQBSUM_BILLING_SUMMARY_CODE,
STATUS,
IN_AUDIT_TYPE,
IN_QUEUE,
IN_EXTERNAL_REFERENCE,
IN_MQ_MESSAGE_ID,
IN_MQ_CORRELATION_ID,
IN_CREATED_DATE,
MODIFIED_USER,
MODIFIED_DATE)
values( ?,
?,
?,
?,
?,
?,
?,
?,
?,
TO_DATE(?,''DD-MON-YYYY HH:mi:ss''),
?,
TO_DATE(?,''DD-MON-YYYY HH:mi:ss''))',
AUDIT_CODE,
MQSSER_SOURCE_SERVICE_CODE,
MQBSUM_BILLING_SUMMARY_CODE,
STATUS,
IN_AUDIT_TYPE,
IN_QUEUE,
IN_EXTERNAL_REFERENCE,
IN_MQ_MESSAGE_ID,
IN_MQ_CORRELATION_ID,
IN_CREATED_DATE,
MODIFIED_USER,
MODIFIED_DATE);
|
in this insert the date conversion of IN_CREATED_DATE doesn't work i get an error about string truncation. BUT (and this is the kicker)  the second conversion (MODIFIED_DATE) is working..
the values in the 2 variables are identical.
Please Help
Thanks
Nico |
|
| 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
|
|
|
|
