Page 1 of 1
error with timestamp column
Posted: Fri Jun 22, 2007 9:41 am
by kirankota79
i am trying to load dataset into a oracle database using oracle stage. For the timestamp column it is saying APT Schema has string , dbms has type 12. Can u please tell what does it mean?
Posted: Fri Jun 22, 2007 1:23 pm
by mhester
This sounds as if you are trying to insert a string into a timestamp. If the db data type for the column is a timestamp then you would need to convert your string to a timestamp and then insert or update.
This sounds reasonable to me......, but I could be way off and often am!
Posted: Fri Jun 22, 2007 1:43 pm
by us1aslam1us
For me it seems that you are trying the other way around Timestamp field to a string of length 12. If that is the case i would suggest you to use some explicit function for this conversion. Also do check the formats of both the source and timestamp field. I do remember sometime back criag discussed about this.