Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsread.com!news-xfer.newsread.com!postnews.google.com!g49g2000cwa.googlegroups.com!not-for-mail
From: goyald@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: How to find Column name - ORA-01438: value larger than specified precision allows
Date: 14 Sep 2005 13:31:31 -0700
Organization: http://groups.google.com
Lines: 12
Message-ID: <1126729891.804922.224820@g49g2000cwa.googlegroups.com>
NNTP-Posting-Host: 12.29.89.6
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1126729897 20460 127.0.0.1 (14 Sep 2005 20:31:37 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 14 Sep 2005 20:31:37 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.8) Gecko/20050511 Firefox/1.0.4,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g49g2000cwa.googlegroups.com; posting-host=12.29.89.6;
   posting-account=0bHxFA0AAABgQqZlRd8M3WLdyYqdB21X
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251529

Hello
I have a very large table with many columns that can cause this. Input
is coming  through external application integration and we do not have
control on code that inserts data in our table. We can however change
precision in the table.

Problem is that I can not find a way to get name of offending column.
Are their any suggestions?


Regards