Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newscore.univie.ac.at!newsfeed01.sul.t-online.de!newsmm00.sul.t-online.de!t-online.de!news.t-online.com!not-for-mail From: Maxim Demenko Newsgroups: comp.databases.oracle.server Subject: Re: How to find Column name - ORA-01438: value larger than specified precision allows Date: Thu, 15 Sep 2005 21:02:45 +0200 Organization: T-Online Lines: 28 Message-ID: References: <1126729891.804922.224820@g49g2000cwa.googlegroups.com> <1126736153.807361.196500@g44g2000cwa.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Trace: news.t-online.com 1126810965 00 26474 VoXYJggrrVcFlWE 050915 19:02:45 X-Complaints-To: usenet-abuse@t-online.de X-ID: bVlmQkZCYem3qZJ1oye5fCCNJQQAB0J4TrWDZ8hrQ0TVC9GvjkxQ6P User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: de-DE, de, en-us, en In-Reply-To: <1126736153.807361.196500@g44g2000cwa.googlegroups.com> Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251642 goyald@gmail.com schrieb: > 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 > You may be interesting in tracing the session with event 10046 at level 4 or 12. In that case you will find in trace file the error 01438 as well as SQL and inserted values. You can enable tracing for certain user via logon trigger ( http://www.evdbt.com/trclvl12.ddl ). Best regards Maxim