Re: External table problem
Date: Fri, 15 Jan 2010 12:41:32 -0600
"But one problem I do see is the definition of the REG and OT columns as NUMBER(3,2) yet some of the data for those columns are "39.02" which is NUMBER (4,2), for example."
Thanks Tim! This was the problem exactly. I changed NUMBER(3,2) to NUMBER (4,2) and then it worked. Not exactly sure why it was reporting an error with the second column when the number formatting was an issue on the fifth and sixth columns though.
I really appreciate the help and have a good weekend everyone!
This e-mail message is intended only for the personal use of the recipient(s) named above. This message is confidential. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify the sender immediately by e-mail and delete the original message.
Received on Fri Jan 15 2010 - 12:41:32 CST