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

Mladen,

Yes, I do set the event to trace the culprit. The problem is that when I enable this event, Oracle is taking around 6 second to return the error msg. on the sql prompt. And ours is a very high OLTP application where around 500 tps take places.
We have request Oracle for an enhancement. Because, when constraints violates, Oracle do gives the constrain name and details, likewise, I would like to have so and so column in the particular table is the culprit.

Regards

Jaffar

On 2/21/07, Mladen Gogala <mgogala_at_vmsinfo.com> wrote:
>
> 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
>
>
>
>

-- 
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA

http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."

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