Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

capture ORA-00942 errors in trace

731838Nov 24 2010 — edited Nov 24 2010

I am using Oracle 10.2.0.4 RAC database on Solaris 10.

One of the testers complained that he was getting ORA-00942 error in the application but he didn't have any clue about the code except for the login details he was using.

So I need to enable trace for all his sessions which I did using LOGON_TRIGGER with 10046 level 12 events but I was not able to capture any ORA-00942 error.
I tried creating a similar trace file for my session and then I faked a similar scenario by creating an anonymous block with some code which did throw ORA-00942 error but once again these were not captured in the trace file.
Is there anyway I can capture these errors in the trace file ?

This post has been answered by 448778 on Nov 24 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 22 2010

Added on Nov 24 2010

#general-database-discussions

4 comments

2,854 views