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

One method would be to start dropping columns from the select statement until you don't get the error. At that point you would know what column it is.

Andrew W. Kerber
Oracle DBA
UMB
816-860-3921
andrew.kerber_at_umb.com

"If at first you dont succeed, dont take up skydiving"

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala Sent: Wednesday, February 21, 2007 10:35 AM To: sjaffarhussain_at_gmail.com
Cc: oracle-l
Subject: Re: How do I get column name that causing ORA-01438

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



------------------------------------------------------------------------------
NOTICE:  This electronic mail message and any attached files are confidential.  The information is exclusively for the use of the individual or entity intended as the recipient.  If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited.  If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

==============================================================================

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