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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How do I get column name that causing ORA-01438

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

From: Mladen Gogala <mgogala_at_vmsinfo.com>
Date: Wed, 21 Feb 2007 11:34:55 -0500
Message-ID: <45DC74AF.4000906@vmsinfo.com>


Syed Jaffar Hussain wrote:
> Hi List,
>
> Is there a way though which I can found out the column name causing an
> ORA-01438?
> I tried tracing the session, unfortunately, the trace file doesn't
> have any cluses about the column causing this error.
> Any link or workaround is appreciated.
ALTER SESSION SET EVENTS='1438 TRACE NAME ERRORSTACK FOREVER, LEVEL 12';

-- 
Mladen Gogala
Sr. Oracle DBA
Video Monitoring Systems
1500 Broadway
New York City, NY 10036
Phone: (212) 329-5201
Email: mgogala_at_vmsinfo.com




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

Received on Wed Feb 21 2007 - 10:34:55 CST

Original text of this message

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