SQL & PL/SQL

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!

Automatically capture oracle errors and exceptions

902488Nov 30 2011 — edited Nov 30 2011

I have requirement of creation of mechanism to capture all oracle errors.

For Eg, when I am running SQL Plus or any oracle client session to perform/execute any command, if any error comes during execution, it can automatically tracked in user defined table with session id which cause error, ora number,timestamp.

I hope requirement is clear. Is there any way to implement?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 28 2011

Added on Nov 30 2011

#dba, #pl-sql, #plsql

12 comments

493 views