Page 1 of 1
TOraLoader: loading TIMESTAMP
Posted: Wed 17 May 2006 12:19
by et
Delphi7 + Oracle 9.2:
How to load a values into TIMESTAMP fields?
PutData and GetColumnData give values as variants.
Neither DateTime nor SQLTimeStamp variants can be loaded.
Posted: Thu 18 May 2006 06:21
by et
Additional info:
When we're trying to store DateTime as TIMESTAMP, it raises EOraError: ORA-26041: DATETIME/INTERVAL conversion error.
When we're trying to store VarSqlTimeStamp as TIMESTAMP, it raises EConvertError: Cannot convert data for FTIMESTAMP column.
In the source code of OraLoader, method TOraLoader.PutColumnData, there are only Number,String,Date variant types.
Posted: Thu 18 May 2006 11:25
by Challenger
OraLoader doesn't support TIMESTAMP type. Please try to use DML arrays instead.
Posted: Fri 19 May 2006 04:03
by et
Ok. Thanks for feedback.