Re: How do I get column name that causing ORA-01438

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 22 Feb 2007 07:57:28 -0700
Message-Id: <20070222145629.2DA1260D7C8@turing.freelists.org>

That is because it is a different error number and message. I also wanted to add that all of those suggested methods of finding the "offending" column work OK for inserts of the form "insert into .. values (...)". But what about an insert of the form insert into xxx select ... from <complex view returning 1000s of rows)

In addition to not knowing which column, you don't even know which row contains the offending value.

At 06:28 AM 2/22/2007, Syed Jaffar Hussain wrote:
>Niall,
>
>I am just surprised to see this result.
>
>We are on 10gR2, we don't get such information as you get when the
>error occurs. Interestingly, Oracle support doesn't mention that its
>available with 10gR2.
>I have just done a simulation test on 10R2 with
><http://10.2.0.3>10.2.0.3 patch, still I don't get the same
>explanation as you have shown.
>
>Can you elabrate more on this.

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 22 2007 - 08:57:28 CST