error with timestamp column

kirankota79 · Post by **kirankota79** » Fri Jun 22, 2007 9:41 am

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?

mhester · Post by **mhester** » Fri Jun 22, 2007 1:23 pm

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!

us1aslam1us · Post by **us1aslam1us** » Fri Jun 22, 2007 1:43 pm

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.