Re: External table problem
- From: Sharon.Kovac@xxxxxxxxxxxxxxx
- To: tim@xxxxxxxxx
- 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!
Sharon
Sharon Kovac | RotoMetrics
Phone: +1 636 587 3600 | Fax: +1 636 587 3701800 Howerton Lane | Eureka, MO
63025 | USA
http://www.rotometrics.com | http://www.myroto.com
---------------------------------------------------------------------
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.
---------------------------------------------------------------------
.
Other related posts:
