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.
TOraLoader: loading TIMESTAMP
-
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.
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.
-
Challenger
- Devart Team
- Posts: 925
- Joined: Thu 17 Nov 2005 10:53