Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find Column name - ORA-01438: value larger than specified precision allows

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

From: <goyald_at_gmail.com>
Date: 14 Sep 2005 15:15:53 -0700
Message-ID: <1126736153.807361.196500@g44g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US