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!g44g2000cwa.googlegroups.com!not-for-mail
From: goyald@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: How to find Column name - ORA-01438: value larger than specified precision allows
Date: 14 Sep 2005 15:15:53 -0700
Organization: http://groups.google.com
Lines: 18
Message-ID: <1126736153.807361.196500@g44g2000cwa.googlegroups.com>
References: <1126729891.804922.224820@g49g2000cwa.googlegroups.com>
   <mo3hi19gue3ch824892d8qooe8d9trou6d@4ax.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 1126736159 28635 127.0.0.1 (14 Sep 2005 22:15:59 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 14 Sep 2005 22:15:59 +0000 (UTC)
In-Reply-To: <mo3hi19gue3ch824892d8qooe8d9trou6d@4ax.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 2.0.40607; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g44g2000cwa.googlegroups.com; posting-host=12.29.89.6;
   posting-account=0bHxFA0AAABgQqZlRd8M3WLdyYqdB21X
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251543

Thanks for the reply. I should have explained my question further.

Error message is
*More text here * exception occurred in
ORA9IDynamicSql::openCursor(StmtExecute)
   ORA-01438: value larger than specified precision allows for this
column

As you will notice, this is a dynamic SQL that gets built somewhere in
program, (from input XML sent by external system), program than tries
to insert/update database. It does not happen often but only sometimes
- when sender system sends data with more precision to our system.

If I can get capture offending SQL than I can try comparing data
fields. I am looking for some suggestions to find this column from
database logs/trace files etc. 
thanks