Detailed Description

Every well-crafted application follows a standard, consistent process for handling, raising and reporting errors. PL/SQL offers a powerful, flexible exception handling architecture, but it does have some limitations. Steven will show you how to take advantage of the latest error management features, work around those limitations, and rely on generic, reusable programs to raise, handle and log exceptions.

Oracle PL/SQL offers a wealth of features and possibilities when it comes to managing errors. Did you know, for example, that in Oracle Database 10g, you can use the DBMS_ERRLOG package to continue past DML errors and log those errors very efficiently? And then there is the totally wondrous DBMS_UTILITY.FORMAT_ERROR_BACKTRACE, which allows us (finally) to obtain the line number on which the error was raised. Of course, there are clouds inside the silver lining. The EXCEPTION datatype in PL/SQL, for example, leaves much to be desired. So much to learn, so many ways to improve our code!