Re: How to find Column name - ORA-01438: value larger than specified precision allows

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 Received on Wed Sep 14 2005 - 17:15:53 CDT