Page 1 of 1

Type mismatch with Oracle database

Posted: Thu Oct 08, 2009 2:56 am
by gssr
I am trying to load a single record:
Error Message:
Type match failure for field TRANSMISSION_DATE; APT Schema has string, dbms has type 12.

Posted: Thu Oct 08, 2009 3:29 am
by ArndW
Oracle type 12 (see the DUMP command) is date, you are supplying a string. Use StringToDate() to convert your string to a date type.

Posted: Thu Oct 08, 2009 4:02 am
by gssr
Thank you,
I converted the string to date and its fine now