Skip to Main Content

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!

Compilation Time Vs Execution Time error tracing/logging

Rajneesh S-OracleFeb 17 2020 — edited Feb 18 2020

Hello All,

I am able to trace all compilation time errors (compilation of PL/SQL procedure) at below inbuilt views:

  • user_errors
  • all_errors
  • dba_errors

pastedImage_2.png

I am wondering if I can trace execution time error as well in any inbuilt table or any log file?

If not then wondering about what all options to log errors into table or redirecting into file than just at script output window for failed procedure's execution.

Basically thinking about logging all errors raised or caught by exceptions during procedure execution.

pastedImage_0.png

This post has been answered by BEDE on Feb 17 2020
Jump to Answer
Comments
Post Details
Added on Feb 17 2020
6 comments
444 views