Re: External table problem
From: <Sharon.Kovac_at_Rotometrics.com>
Date: Fri, 15 Jan 2010 12:41:32 -0600
Message-ID: <OFA10AEE94.55E2081B-ON862576AC.006663EC-862576AC.0066AECE_at_Rotometrics.com>
"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."
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.
Date: Fri, 15 Jan 2010 12:41:32 -0600
Message-ID: <OFA10AEE94.55E2081B-ON862576AC.006663EC-862576AC.0066AECE_at_Rotometrics.com>
"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.
.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 15 2010 - 12:41:32 CST