RE: How do I get column name that causing ORA-01438
- From: "Kerber, Andrew" <Andrew.Kerber@xxxxxxx>
- To: mgogala@xxxxxxxxxxx, sjaffarhussain@xxxxxxxxx
- Date: Wed, 21 Feb 2007 11:03:01 -0600
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@xxxxxxx
"If at first you dont succeed, dont take up skydiving"
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mladen Gogala
Sent: Wednesday, February 21, 2007 10:35 AM
To: sjaffarhussain@xxxxxxxxx
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@xxxxxxxxxxx
------------------------------------------------------------------------------
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.
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
