Inserting a TimeStamp Value into Oracle Database
Posted: Thu Dec 09, 2004 6:28 am
Hi
I am unable to insert a Timestamp DataType value into and Oracle 9i database. I'm using an ODBC Stage with User Defined SQL as the Update Action.
Please help
TIA
I am unable to insert a Timestamp DataType value into and Oracle 9i database. I'm using an ODBC Stage with User Defined SQL as the Update Action.
Code: Select all
lookup..Transformer_11.DSLink13: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO COMET_ETL.CHECKDATETIME(ID, CITY, CURRENTDATE) VALUES (?,?,TO_DATE(?, 'MM-DD-YYYY HH24:MI:SS'))
SQLSTATE=22008, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]Datetime field overflow. Error in parameter 3.
ID = "1"
CITY = "2"
CURRENTDATE = "12-09-2004 17:51:29"
TIA